How do I setup iReport to run against SQLEXPRESS 2

[rsassine]

Hello All,

I've tried everything for a whole day to get iReport 2.0 to run against my SQL Express 2005 to no avail.

 

1. I've used and downloaded sqljdbc.jar for Microsoft to no avail. I've checked this site: http://blogs.msdn.com/jdbcteam/ for mistake that could be there. There was one: SQL Express 2005 uses:"com.microsoft.sqlserver.jdbc.SQLServerDriver", NOT "com.microsoft.jdbc.sqlserver.SQLServerDriver". I've fixed it - No dice.

By the way sqljdbc.jar could not be unzipped; I got a bad file error.

 

2. I've used the sourceforge: "net.sourceforge.jtds.jdbc.Driver" also to no avail.

 

It's drving me insane. Any one out there had the same issues. If you resolved it, please help.

 

thanks,

Raymond [file name=ScreenShot003.jpg size=107809]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ScreenShot003.jpg[/file]

[nealhudson]

I also having trouble with this. The farthest I've got is by using the jTDS driver technique described here:
http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=309#309


and the connection string url:
jdbc:jtds:sqlserver://localhost:1433/myDatabase;instance=SQLEXPRESS

I then get the error:
SQL problems: Unable to get information from SQL Server: localhost.
jdbc:jtds:sqlserver://localhost:1433/myDatabase;instance=SQLEXPRESS

 

[nealhudson]

I just tried the method using the System DSN and this worked