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.
2 Answers:
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.
I assume you are talking about the JasperReports Library, right?
Issue solved when I connect with jdbc 9.4.0 jar file. Before i am used jdbc42 for 6.8.0 version