SQL Server Developer Center > SQL Server Forums > SQL Server Data Access

SQL Server Data Access

Questions and discussion about data access to SQL Server using SQL Native Client, OLEDB, ODBC, ADO, WDAC/MDAC, JDBC, or SOAP/HTTP.

Announcements

SQL Server JDBC Driver v2.0 is now available
Jimmy Wu - MSFT Tuesday, January 27, 2009 1:24 AM
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, NCLOB

·        SQLXML data type

·        Wrapper interface to access SQL Server JDBC Driver specific methods

·        client info properties

·        new database metadata methods

·        LOB creator methods

The 2.0 driver also adds:

·        default adaptive response buffering behavior

·        support for SQL Server 2008 collations

·        enhanced tracing, including public method entry and exit traces

·        performance improvements and bug fixes

Please feel free to download a copy and see for yourself!
The ADO.NET Managed Providers team wants to hear your opinion
Zlatko Michailov - MSFT Monday, November 02, 2009 7:53 PM
This is the time when we, the ADO.NET Managed Providers product team, take a step back, review our goals for the next release and identify areas for investments.

We view YOU as a key stakeholder in this process and would like to gather your inputs in this survey, which should take no more than 10 - 15 minutes. The answers you provide will give us the background for some of the key decisions that will benefit our database community - developers, DBAs and everybody who use SQL Server or are looking for ways to expand its scope.

This survey will be valid until November 13, 2009 and can be found at https://www.surveymonkey.com/s.aspx?sm=DJv_2brczgTusUJkolYrczAQ_3d_3d.

Thank you in advance,
Luiz Santos
Senior Program Manager, SQL Connectivity
SQL Server 2005 SP3 is now available for upgrade
Ed LehmanMSFTTuesday, December 16, 2008 1:35 AM
SP3 provides a roll-up of QFE work done since SP2, as well as addresses critical issues reported through the SQL Server community. Per revised servicing strategy for SQL Server releases, SP3 does not introduce major new features. We have also refreshed the Feature Pack for SQL Server 2005 SP3 along with this release.
- SP3 can be used to upgrade from any previous instance of SQL Server 2005
- For customers who are going to be upgrading from SQL Server 2005 SP2 CU#10 or SP2 CU#11, you will have to install the latest CU on SP3 after upgrading to SP3 release to get all the fixes.
SP3 applies to:
The SQL Server SP3 update for all editions of SQL Server 2008 will be available on Microsoft Update on Jan 27^th.

Download SQL Server 2005 SP3

Download SQL Server 2005 SP3 Express

Download SQL Server 2005 Feature Pack Refresh - December 2008

What's new in SQL Sserver 2005 SP3

Latest Books On-Line Update