Ms Sql 2008 R2 Jdbc Driver Download

1. Microsoft Sql Server 2008 R2 Jdbc Driver Download
2. Download Sql 2008 R2 Developer
3. Microsoft Sql Server 2008 R2

List of JDBC drivers for SQL Server 2008. Official Microsoft JDBC driver for SQL Server 2008! Download the SQL Server JDBC Driver 2.0. SQL Server 2008 or SQL Server 2005 or SQL Server 2000.

I am in the process of evaluating a whole whack of JDBC drivers, specifically to use with SQL Server 2008 with Windows authentication. I gathered a list of ones that I found and have listed them below.

My question is, are there any other JDBC drivers that are compatible with SQL Server 2008 that I should also look into reviewing?

1. Microsoft JDBC driver

   It is basically designed for solid modeling with support for adjusting the different solid properties like density and other similar properties. You ca design different components with ease and perfection. Download pro e wildfire 4.0. Visualize different components before actually implementing them. Getting hands on this application open many doors for you in the industry.

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

   Pros: Official Microsoft JDBC driver for SQL Server 2008! Based on the JNetDirect JSQLConnect driver v3 as it was purchased by Microsoft a few years ago and they have been building on top of it since. I was told this by JNetDirect JSQLConnect's support.

   Cons: Seems to have a lot of connectivity/stability issues, don't believe me, just Google about it :). Doesn't have a way of disabling statement preparation/pooling which is something I am looking for.

   JDBC compliance: Claims to be be JDBC 4.0 compliant although many methods throw UnimplementedException!!!!

   JDBC Type: 4

   Price: Free

2. Progress DataDirect

   URL: http://www.datadirect.com/index.html

   Pros: Claims to be top class, used by numerous applications like Informatica, etc and the company is been around for ages! Have quick support - I have dealt with them briefly.

   Cons: ?

   JDBC compliance: Claims to be be JDBC 4.0 compliant

   JDBC Type: 5

   Price: Not free

3. JTDS

   URL: http://jtds.sourceforge.net/

   Pros: Much faster than the official Microsoft JDBC driver. Has a way of disabling prepared statements.

   Cons: ?

   JDBC compliance: JDBC 3.0 compliant only. This is a deal breaker for me because important methods like .validate() and .isClosed() aren't supported because these are JDBC 4.0 methods.

   JDBC Type: 4

   Price: Free - Open Source

4. INET Merlia

   URL: http://www.inetsoftware.de/products/jdbc-driver/ms-sql/merlia

   Pros: Much faster than the official Microsoft JDBC driver. Has a way to disable prepared statements.

   Cons: ?

   JDBC compliance: Claims to be be JDBC 3.0/4.0 compliant

   JDBC Type: 4

   Price: Not free

5. JNetDirect JSQLConnect

   URL: http://www.jnetdirect.com/products/jsqlconnect.html

   – This Patch has Built on Konami official 3rd update. – All Winter Transfers & Latest Squads For All Clubs & National Teams. – All Real Names, Flags & HD Emblems For All Teams, Players & Championships.

   Pros: Much faster than the official Microsoft JDBC driver. Has a way to disable prepared statements

   Cons: ?

   JDBC compliance: Claims to be be JDBC 3.0/4.0 compliant

   JDBC Type: 4

   Price: Free for a single user with only 1 database connection.

If you can keep your comments clean, I'll happily update this post with any others.

closed as not a real question by BalusC, skaffman, user177800, Michael Myers♦Aug 4 '11 at 15:59

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged javasql-server-2008jdbcjtds or ask your own question.

My configuration:

• windows XP SP3
• JDBC 2005
• MS SQL Server 2008 Express, exposed via tcp/ip on port 1433
• sqljdbc.jar in class path

I tried:

But it always throws an exception:

I also tried the following urls:

Same results. Any help?

6 Answers

You have the wrong URL.

I don't know what you mean by 'JDBC 2005'. When I looked on the microsoft site, I found something called the Microsoft SQL Server JDBC Driver 2.0. You're going to want that one - it includes lots of fixes and some perf improvements. [edit: you're probably going to want the latest driver. As of March 2012, the latest JDBC driver from Microsoft is JDBC 4.0]

Check the release notes. For this driver, you want:

It seems you have the class name correct, but the URL wrong.

Microsoft changed the class name and the URL after its initial release of a JDBC driver. The URL you are using goes with the original JDBC driver from Microsoft, the one MS calls the 'SQL Server 2000 version'. But that driver uses a different classname.

For all subsequent drivers, the URL changed to the form I have here.

This is in the release notes for the JDBC driver.

1. Download the latest JDBC Driver (i.e. sqljdbc4.0) from Microsoft's web site

2. Write the program as follows:

3. Compile the program and set the jar classpath viz: set classpath=C:jdbcsqljdbc4.jar;.; If you have saved your jar file in C:jdbc after downloading and extracting.

4. Run the program and make sure your TCP/IP service is enabled. If not enabled, then follow these steps:
   1. Go to Start -> All Programs -> Microsoft SQL Server 2008 -> Configuration tools -> SQL Server Configuration Manager
   2. Expand Sql Server Network Configuration: choose your MS SQL Server Instance viz. MSQSLSERVER and enable TCP/IP.
   3. Restart your MS SQL Server Instance. This can be done also from the right click menu of Microsoft SQL Server Management Studio at the root level of your MS SQL server instance

If your databaseName value is correct, then use this: DriverManger.getconnection('jdbc:sqlserver://ServerIp:1433;user=myuser;password=mypassword;databaseName=databaseName;')

The latest JDBC MSSQL connectivity driver can be found on JDBC 4.0

The class file should be in the classpath. If you are using eclipse you can easily do the same by doing the following -->

Right Click Project Name --> Properties --> Java Build Path --> Libraries --> Add External Jars

Also as already been pointed out by @Cheeso the correct way to access is jdbc:sqlserver://server:port;DatabaseName=dbname

Meanwhile please find a sample class for accessing MSSQL DB (2008 in my case).

Hope this helps.

Microsoft Sql Server 2008 R2 Jdbc Driver Download

Named instances?

URL: jdbc:sqlserver://[serverName][instanceName][:portNumber][;property=value]

Note: backward slash

Download Sql 2008 R2 Developer

You can try the following. Works fine in my case:

1. Download the current jTDS JDBC Driver
2. Put jtds-x.x.x.jar in your classpath.
3. Copy ntlmauth.dll to windows/system32. Choose the dll based on your hardware x86,x64..
4. The connection url is: 'jdbc:jtds:sqlserver://localhost:1433/YourDB' , you don't have to provide username and password.

Hope that helps.

Microsoft Sql Server 2008 R2

Not the answer you're looking for? Browse other questions tagged javasql-serverjdbc or ask your own question.