On a Windows platform, when trying to connect to SQL Server using Integrated Authentication, you may see this exception: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. along with the following...

If you are seeing this exception while trying to use the SQL Server 2005 JDBC driver, then you will need to update the application. The class name has changed between the SQL Server 2000 JDBC driver and the SQL Server 2005 JDBC driver. This particular...

Unsure of what to specify in the connection URL? Having trouble configuring the driver for Integrated Authentication? Confused about some behavior with the Microsoft SQL Server JDBC driver? Then, this is the blog site for you. The SQL Server JDBC team...

The Microsoft SQL Server JDBC team is proud to announce the availability of our v1.2 CTP2 (beta) release. The driver is downloadable at http://msdn.microsoft.com/data/jdbc . The direct link to the download page is http://www.microsoft.com/downloads/details...

Many of you have asked us before, "Is the Microsoft SQL Server JDBC driver supported by IBM WebSphere?". Now, we have the answer. In collaboration with the IBM WebSphere team, the SQL Server JDBC team is happy to announce starting with IBM WebSphere 6...

We are excited to announce the newest release of the Microsoft SQL Server JDBC Driver 2.0 ! This version of the JDBC driver supports features introduced in the JDBC 4.0 API, including: · national character set data types: NCHAR, NVARCHAR, LONGNVARCHAR...

If you've ever encountered this error with the Microsoft SQL Server JDBC Driver, you may be left scratching your head, wondering a) what it means, and b) why it is occurring. I'll tackle these in order... But if you're not interested in the details, skip...

What is SSL and why is my JDBC driver using it? The v1.2 JDBC driver uses SSL (Secure Sockets Layer) to encrypt connections to SQL Server for improved security. Where it can, the v1.2 driver ALWAYS uses SSL to encrypt the login to SQL Server. For integrated...

Dear SQL Server developers and users: On behalf of Microsoft SQL Server JDBC team I am very excited to announce our latest JDBC driver Microsoft SQL Server JDBC 3.0 release. This version of the JDBC driver provides support for features introduced...

Since SQL Server 2008 release over the summer, people have been asking, "So, does the existing JDBC driver work with SQL Server 2008?" or "When will there be a SQL Server 2008 JDBC driver?". There are many things to consider with a general questions...

Per JDBC spec, the Statement.executeUpdate() and Statement.executeQuery() methods are to be used only with queries that produce a single update count or result set, respectively. If you need to execute multiple SQL statements in a single query, perhaps...

Have you ever encountered this exception from executeQuery()? If so, chances are good that your query actually did return a result set (we’ll be addressing the error message text... ), but it wasn’t the first result. Look at your query or stored procedure...

Dear SQL Server Developer Community, I am pleased to report that the Microsoft JDBC Driver 4.0 for SQL Server is now released . Thank you for all your great feedback on our three community technology previews (CTP). Our 4.0 release contains some great...

The Microsoft SQL Server JDBC team is proud to announce the general availability of the v1.2 RTW release. The driver can be found at http://msdn.microsoft.com/data/jdbc . In this release we significantly reduced the driver's memory footprint usage especially...

Do you currently use selectMethod=cursor to work around OOM errors with very large result sets? Do you find that the driver seems to consume quite a lot of memory for forward only read only result sets? Does it seem like it takes a long time to return...

In the previous post "Working with SQL Server 2008 Date/Time Data Types using v1.2 JDBC driver" ,I talked about how the current JDBC driver can interop with the new Date/Time/DateTime2/DatetimeOffset data types. This time around, I will describe how to...

Since the release of SQL Server 2008, we have heard from customers looking for a JDBC driver that supports SQL Server 2008. I would like to use this post to ask you, our customers, which features of SQL Server 2008 do you need supported through the JDBC...

Dear SQL Server developers and users: Thank you for your ongoing support of the Microsoft JDBC Driver for SQL Server. We have an update on the connection issues some of you experienced when using Java 6 update 29 and above. Java 6 update 29 (6u29...

Given the release of the Microsoft SQL Server JDBC Driver 3.0 , the Microsoft SQL Server JDBC team has discontinued the download for Microsoft SQL Server JDBC Driver 1.2. Please let us know if you perceive any issues with your solution or customers...

Dear SQL Server developers and users: In the last few weeks, I have received a number of queries on which driver version is supported with which SQL server version. I have created a support matrix describing the supported configuration. Matrix also...

Dear SQL Server developers and users: As a follow up to my last post regarding the next release of our JDBC driver called the Microsoft JDBC Driver 4.0 for SQL Server, I am very pleased to announce the availability of our first community technology...

Dear SQL Server developers and users: On behalf of Microsoft SQL Server JDBC team I would like t hank you for the valuable feedback and support on our Microsoft SQL Server JDBC driver. In response to your feedback since last year’s release of the Microsoft...

Dear SQL Server developers and users: Thank you for your ongoing support of the Microsoft JDBC Driver for SQL Server. We have recently had some questions regarding which versions of Java are supported by the Microsoft JDBC Driver for SQL Server...

Dear SQL Server and SQL Azure developers and users: We are very pleased to announce the availability of an updated version of Microsoft SQL Server JDBC Driver 3.0 supporting Microsoft SQL Azure database: http://www.microsoft.com/downloads/en/details...

Dear SQL Server developers and users: Thank you for your ongoing support of the Microsoft JDBC Driver for SQL Server. Some of you reported problems with dates when using JRE 1.7. The Microsoft JDBC Driver for SQL Server currently supports JRE 1...