surima.tvs3 Posted January 31, 2023 Share Posted January 31, 2023 We are trying to connect a database MSSQL from the jasper version 6.20.0 (Open source). can't connect the Database. But connections happened in jasper version 6.8.0 (licensed version).Any one of you please help us to move forward. Link to comment Share on other sites More sharing options...
Raphaël Peguet Posted February 2, 2023 Share Posted February 2, 2023 I assume you are talking about the JasperReports Library, right? Link to comment Share on other sites More sharing options...
Raphaël Peguet Posted February 2, 2023 Share Posted February 2, 2023 The JasperRreports Library is completely agnostic and makes no assumption as to where the data used to fill the report comes from so there is no limitation in building reports using data from MSSQL.Please review the ultimate guide page 20 (p. 32 in the PDF) and page 68 (p. 80 in the PDF) for more information https://community.jaspersoft.com/documentation/jasperreports-library-ult...With a SQL Server DB as a datasource the easiest is to define the SQL query in the template and to pass the connection object at runtime. In that case you only need to make sure the connection is successful and the query is valid. Link to comment Share on other sites More sharing options...
surima.tvs3 Posted February 8, 2023 Author Share Posted February 8, 2023 Issue solved when I connect with jdbc 9.4.0 jar file. Before i am used jdbc42 for 6.8.0 version Link to comment Share on other sites More sharing options...
Solution surima.tvs3 Posted February 8, 2023 Author Solution Share Posted February 8, 2023 Issue solved when I connect with jdbc 9.4.0 jar file. Before i am used jdbc42 for 6.8.0 version. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now