Cant create data access to MsSql 2005

0

Hi,

I´trying to test Jasoer por the first time.

I´ve installed Jasper Studio 1.1.1 and when I try to Create a Data Adapter using Configure JDBC  connection with any of the MsSql server options I allways get a Class not found exception error.

No way to use it, the help is blanked.

Any help please

TIA

Alberto

michelis's picture
Joined: May 25 2012 - 8:23am
Last seen: 2 years 5 months ago

6 Answers:

0

you have to add jdbc driver to classpath

Veaceslav Chicu

chicuslavic's picture
Joined: Apr 19 2010 - 3:18am
Last seen: 1 month 2 weeks ago
0

And how do I do it?

Please be more especific.

michelis's picture
Joined: May 25 2012 - 8:23am
Last seen: 2 years 5 months ago
0

 Just add an external jar file using the application.

drodinthe559's picture
Joined: Apr 30 2008 - 8:53pm
Last seen: 6 years 5 months ago
0

method 1: in DataAdapter dialog look at Classpath tab, add your jar here

method 2: in your project you should have a lib folder with ms sql server jdbc driver, right click on it, and look for Build Path -> Add to Build Path

 

Veaceslav Chicu

chicuslavic's picture
Joined: Apr 19 2010 - 3:18am
Last seen: 1 month 2 weeks ago
0

Ok, but, where do I found the ms sql server jdbc driver?

michelis's picture
Joined: May 25 2012 - 8:23am
Last seen: 2 years 5 months ago
0

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

I used type 4 jdbc driver, this one is pure java

chicuslavic's picture
Joined: Apr 19 2010 - 3:18am
Last seen: 1 month 2 weeks ago
Feedback