Connect to SQL Server 2008 using iREPORT 3.5.0

[kishorepalle]

Hello members,

I am new to reporting environment. I started playing around with Jasper as part of learning curve. I am using iReport 3.5.0 (latest build) and after much effort, I could connect to SQL 2000 database and publish some reports.

The thing I have a problem with is, I would like to connect to SQL Server 2008 database (installed locally) but I don't see the JDBC driver that reads anything for SQL Server 2008 under the JDBC Driver drop down list box. (please refer to the attached screenshot).

Any help you can extend on how to connect to the SQL Server 2008 is highly appreciated.

Thanks

Kishore

[Giulio Toffoli]

The list just shows a list of common JDBC drivers, not all the available ones. The combobox is editable, you can write in the name of the correct driver for Microsoft SQL server 2008.
Be sure you have the driver jar (sqljdbc.jar) in the iReport classpath (Tools->Options->ireport->classpath)

The driver is available here:
http://www.microsoft.com/downloads/details.aspx?familyid=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en

Driver name: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC url: jdbc:sqlserver://HOSTNAME:1433;databaseName=DATABASENAME;

Giulio

[vaishalijain7]

Hi,

 

I am also facing the same problem and if I put com.microsoft.sqlserver.jdbc.SQLServerDriver to connect to SQLServer 2008 it automatically picks SQLServer 2005 because that's also having same name.

 

Please suggest what to do to overcome the problem.

 

Thanks

Vaishale

[Giulio Toffoli]

You have just set the driver name, if iReport shows the label SQLServer 2005 it's not a problem. Be sure you have put the driver in the classpath, since iReport does not ship any SQLServer driver.

Giulio

[george1916]

Hi,

 

I have just started looking at Ireports and my major problem is Data connections

I am trying to connect to SQL 2008

I have downloaded the driver as per your instructions

 

I have attached the error I am getting

 

Please help

 

Regards

 

George

[lknueve]

Did you put the driver location in your classpath? Also, didn't see a username/password entered, so when testing the connection, you need to make sure those are entered as well.

 

[shatad0101]

Hi

 

  I have one problem with connection of Ms Sql 2008 R2 for 32 bit with ireport 4.0.0,

i have downloaded mn sql driver

http://www.microsoft.com/download/en/confirmation.aspx?id=2505

and put sqljdbc4.jar file in program file but still i am not able to connect.

 

Actually i installed ms sql with windows authentication and when i try to make coooonection in i report and jasper server 

it asking for user name ,and password in jasper server as well as in ireport.

 

any one can help me please,

[lknueve]

Make sure your connection JDBC URL looks something like the following:

 

jdbc:sqlserver://<servername or ip address>;databaseName=<database name>

 

Then you'll have to enter in your username/password that you use to login to Windows since you used windows Auth for sql server.

[shatad0101]

 Hi ,

   Thanx for reply 

 

Actually when i installed sql server it didnt ask me for any user name and password in windows authentication.

Driver name --com.microsoft.sqlserver.jdbc.SQLServerDriver

URL--jdbc:sqlserver://ServerName:1433:databaseName=Mydatabase;

 

i have downloaded ---- Microsoft SQL Server JDBC Driver 3.0

and put Sqljdbc4.jar in this

-----location   C:\Program Files\jasperreports-server-cp-4.0.0\apache-tomcat\webapps\jasperserver\WEB-INF\lib

can you check whether it is right or wrong