knobboll Posted August 21, 2007 Share Posted August 21, 2007 Hi, I try to run a report with a subreport in JS. I have created the report via ireport and moved it to the server via the plugin.The main report and the subreport both accessing data from SQL Server. The reports are fine as standalone reports but when I run the report including the subreport in JS I get the error message: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Does anyone know a solution to this problem? Thanks, Clem Link to comment Share on other sites More sharing options...
lucianc Posted August 23, 2007 Share Posted August 23, 2007 Google knows the answer to most problems. According to Microsoft, you'll have to set SelectMethod=Cursor for the JDBC connection. HTH,Lucian Link to comment Share on other sites More sharing options...
knobboll Posted August 24, 2007 Author Share Posted August 24, 2007 Thanks for the information. As I was trying to access SQL Server 2005 I also realized that I need the 2005 driver because the 2000 driver is not compatible with the 2005 server. It's working now :-) 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