sqlserver2005 Check username and password: is the DBMS active

[zdzhanghj]

I am using Jaspersoft iReport Designer 5.6.0 and sqljdbc.jar and I want to associate a query to a new report.I have successfully created a SQL Server (2005) connection with the JDBC driver in iReport, and test is OK. But using query language of SQL("select * from table") fails in report query.I click button of "Read Fields" ,it shows "Error:General problem:null Check username and password; is the DBMS active?!". And clicks "Preview data",it can read the count of records.I think the connetion is success ,but data can not show

[hozawa]

Have you tried using JDBC 4.0 driver (sqljdbc4.jar)?

http://www.microsoft.com/en-us/download/details.aspx?id=11774

[zdzhanghj]

Errors still exist。uses jdk1.6.0_20 ， jre6， sqljdbc4.jar