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 AMWe 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 PMThis 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 ConnectivitySQL Server 2005 SP3 is now available for upgrade
Ed LehmanMSFTTuesday, December 16, 2008 1:35 AMSP3 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:
- SQL Server 2005 Enterprise Edition
- SQL Server 2005 Enterprise Evaluation Edition
- SQL Server 2005 Developer Edition
- SQL Server 2005 Standard Edition
- SQL Server 2005 Workgroup Edition
The SQL Server SP3 update for all editions of SQL Server 2008 will be available on Microsoft Update on Jan 27th.
Download SQL Server 2005 SP3
Download SQL Server 2005 Feature Pack Refresh - December 2008
Download SQL Server 2005 SP3 Express
What's new in SQL Sserver 2005 SP3
Latest Books On-Line Update
Filtering and SortingUse these options to narrow down the question and discussion list.
- 06072

Guidelines when posting JDBC related questions
Jimmy Wu - MSFT Saturday, August 02, 2008 12:44 AM - 012936

Steps to troubleshoot SQL connectivity issues
Xinwei Hong - MSFT Wednesday, April 30, 2008 4:40 PM - 8178

Can't run SSIS package from a batch file
Steve Hempen Tuesday, November 03, 2009 10:05 PM - 3113

10/09 Security Update Hinders OLE DB connectivity ?
Rickshawrentals Friday, November 20, 2009 4:05 PM - 1109

Why, after importing a database into SQL 2008 can I not delete new records from a table in an Access interface over obdc? I get a 3197 error.
zipitllc Thursday, November 19, 2009 9:09 PM - 019

Problem with Linked Server and Microsoft.ACE.OLEDB.12.0
Roger Rowe 7 hours 43 minutes ago - 259

SQL 2K Simple Stored Procedure Times Out when Called by .Net Web Site
Ted Cooper 17 hours 43 minutes ago - 038

Cache Stored Procecdure call in DTS
thФrи 14 hours 13 minutes ago - 147

How to optimize mysql subquery performance?
Add-On 16 hours 50 minutes ago - 021

Database connection, c# application.
Mankeer C-Sharp Programmer 16 hours 48 minutes ago - 049

problem with foxpro table data in sql linked server
john_tig 20 hours 38 minutes ago - 1103

Connecting and send data to SQL server in 'C'
asm_2_hex Sunday, November 22, 2009 6:22 AM - 1115

Problem with SQL string
ryguy72 Saturday, November 21, 2009 7:12 PM - 63726

"A transport-level error has occurred "- while connecting to SQL Server 2005
Jaydeepsinh Sunday, July 27, 2008 1:36 PM - 2024961

ODBC connection failing on 64 version of Windows 2003 server
bbauer Wednesday, May 03, 2006 4:59 PM - 1154

How to resolve this? A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Jone Li Friday, November 20, 2009 10:20 AM - 499

Network-related or instance-specific error - Connection Medium Problem
Fallerian Thursday, November 19, 2009 1:36 PM - 1722197

Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied.).
Jasdeep Tuesday, January 23, 2007 6:01 AM - 5183

ODBC Error: SQLState 28000 & Server Error 18452
ManAtRest Wednesday, November 18, 2009 1:42 PM - 088

Connect SQL Server from WinForms - Windows Authentication Mode
Lubos Hladik Friday, November 20, 2009 12:39 PM


