JDBC for SQL Server

Hi

Can anyone please help me to provide the JDBC driver for SQL Server which can be used in BIRT?

Thanks
Shréè

Find more posts tagged with

Comments

Hi Shréè, 
 
Actuate BIRT has the SQL Server JDBC Driver already installed. You can download it at: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/downloads/birt-report-designers/'>http://www.birt-exchange.com/downloads/birt-report-designers/</a> 
 
It also looks like you can download the driver for SQL Server at Microsoft.com as well. Here's a link for the SQL Server 2005 JDBC Driver 1.2: 
 
<a class='bbc_url' href='http://www.microsoft.com/downloads/details.aspx?FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba&DisplayLang=en'>http://www.microsoft.com/downloads/details.aspx?FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba&DisplayLang=en</a> 
 
Hope this helps.

vikasg18

add sqljdbc.jar into eclipseplugins and give the
Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver (v2.0)
Driver URL: jdbc:sqlserver://localhost:1433
and provide ur DB username and password.

-Vikas

kdw

<blockquote class='ipsBlockquote' data-author="vikasg18">add sqljdbc.jar into eclipseplugins and give the 
Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver (v2.0) 
Driver URL: jdbc:sqlserver://localhost:1433 
and provide ur DB username and password. 
 
-Vikas</blockquote>
 
I'm also new to BIRT, and thought I've set up Microsoft jdbc driver correctly. Well, I guess not. 
 
At one point as I tried to get this to work using sqljdbc.jar, I was told via popup that apparently sqljdbc4.jar is needed for jdk 1.6. So I added sqljdbc4.jar via the Manage Drivers wizard. 
 
I used: 
 
jdbc:sqlserver://localhost:1433;databaseName=<my database> 
 
and giving it what should be a good uid/pw. 
 
The Test Connection generates an 'unhandled event loop exception' which shows the call trace seen below. 
 
Is there any other magical lore that would get this connection made?? 
 
 
java.lang.NoClassDefFoundError: com/microsoft/sqlserver/jdbc/SQLServerConnection 
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:840) 
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1112) 
at java.sql.DriverManager.getConnection(Unknown Source) 
at java.sql.DriverManager.getConnection(Unknown Source) 
etc 
etc

mmah

You can also try the JTDS driver found in SourceForge. This is the universal SQL driver that works better than the Microsoft provided driver.