JDBC driver is not recognize sql server drives

0

Hi All

i'm tring to understand want i'm doing wrong , my steps are :

1.installing the jasper 5.1 server & IReport 

2.install the lateste JRE ( the current version is 7.21)

3.download the JDBC 4.0 version

4.coyied the sqljdbc4.jar file to the "Program Files\jasperreports-server-5.1\java\jre\lib\ext" folder

5.refresh tomcat & postgreSql services

6.tring to create a sql datasources connecting   with com.microsoft.sqlserver.jdbc.SQLServerDriver  

the drive selection item is in red color and i cannot create the datasource (getting a message that the drive is missing)

thanks 

 

amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 5 years 1 week ago

4 Answers:

0

you have to place the driver either in the tomcat director (sth. like <jasperserver-install>/apache-tomcat/lib/) or in the libs-dir of the webapplication (sth. like <jasperserver-install>/apache-tomcat/webapps/jasperserver/WEB-INF/lib/)

both should work

Cheers, Thomas

http://www.thomaszimmer.net

Thomas Zimmer's picture
Joined: Oct 2 2012 - 1:35am
Last seen: 5 days 12 hours ago
0

still having the same problem

i placed the sqljdbc4 file on:

1.Program Files\jasperreports-server-5.1\apache-tomcat\lib  ( on this folder there was another file sqljdbc-1.6-2206.100.jar)

2.Program Files\jasperreports-server-5.1\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib

3.Program Files\jasperreports-server-5.1\java\jre\lib\ext

and still i cannot create a datasource for sql server

thasnks

amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 5 years 1 week ago
0

it finally worked !!

i guess the last step fixed the problem ,

just did the most common thing that fixes all problems ... restart :) 

thanks for the help

 

amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 5 years 1 week ago

sorry I forgot to say, that you have to restart the application server after including the libs ... :-)

Thomas Zimmer - 6 years 5 months ago
0

Yep.. Actuallly restarting tomcat is needed. That process is described here: http://community.jaspersoft.com/wiki/connecting-jasperreport-server-your... and since the driver is in the tomcar/lib folder it will allow you to create JNDI connections which have better performance since they benefit from the application server connection pooling.

Also is important to note that since you are using 5.1 there is a new feature that allows you to upload and dynamically use JDBC drivers from the Jasperserver UI. You need to be logged in as a superuser and you have the option to add drivers when you create your datasource. The process is described in the JasperServer Admin Guide Chapter 4.1 (section 4.1.2) http://community.jaspersoft.com/documentation

marianol's picture
4768
Joined: Sep 13 2011 - 8:04am
Last seen: 1 year 1 month ago
Feedback