evan.warrick Posted December 13, 2021 Share Posted December 13, 2021 My datasource connection tested ok but my SQL test query results in this error:The active connection is not a JasperReports DataSource provider. Link to comment Share on other sites More sharing options...
evan.warrick Posted December 13, 2021 Author Share Posted December 13, 2021 Here is the DB JDBC connection: JDBC Driver = MS SQLServer (2005) (com.microsoft.sqlserver.jdbc.SQLServerDriver)JDBC URL = jdbc:sqlserver://db.enterworks.internal:1433;databaseName=JasperReports;SelectMethod=cursor Link to comment Share on other sites More sharing options...
evan.warrick Posted December 14, 2021 Author Share Posted December 14, 2021 I'm running an old version due to client requirements: Jaspersoft iReport Designer Professional 5.2.0 Link to comment Share on other sites More sharing options...
evan.warrick Posted December 14, 2021 Author Share Posted December 14, 2021 This is resolved. 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