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.
공지 사항
SQL Server JDBC Driver v2.0 is now available
Jimmy Wu - MSFT 2009년 1월 27일 화요일 오전 1:24We 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 2009년 11월 2일 월요일 오후 7:53This 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 LehmanMSFT2008년 12월 16일 화요일 오전 1:35SP3 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
필터링 및 정렬토론 목록의 범위를 좁히려면 이러한 옵션을 사용하십시오.
- 06094

Guidelines when posting JDBC related questions
Jimmy Wu - MSFT 2008년 8월 2일 토요일 오전 12:44 - 012988

Steps to troubleshoot SQL connectivity issues
Xinwei Hong - MSFT 2008년 4월 30일 수요일 오후 4:40 - 021

Creating offline OLAP cube with C#.
Jimmy Joe 2시간 43분 전 - 022

I get 'access denied' when trying to read/write filestream on w2k8 r2.
Antal István1 2시간 58분 전 - 033

connection pooling
jjpark 3시간 41분 전 - 389

SQL 2K Simple Stored Procedure Times Out when Called by .Net Web Site
Ted Cooper 2009년 11월 23일 월요일 오전 6:00 - 146

SQL Server DIFF Backup
Bala.ausi 10시간 9분 전 - 034

Cannot create new user using createuserwizard using IE
FredEWeb 6시간 59분 전 - 2167

Connecting and send data to SQL server in 'C'
asm_2_hex 2009년 11월 22일 일요일 오전 6:22 - 385

Database connection, c# application.
Mankeer C-Sharp Programmer 2009년 11월 23일 월요일 오전 6:55 - 1110

Connect SQL Server from WinForms - Windows Authentication Mode
Lubos Hladik 2009년 11월 20일 금요일 오후 12:39 - 1188

SQL STATE 22003: Numeric value out of range" with TIME datatype of SQL server 2008
Jim Buck 2009년 11월 20일 금요일 오전 1:58 - 191

MFC ADO application slow when connected via OLE DB Provider for SQL Server, fast when connected via SQL Server Native Client 10.0
hotblack944 2009년 11월 19일 목요일 오전 11:07 - 027

MS Access ADP projects need to be able to use SQL Native Client
Trumpy 21시간 55분 전 - 147

Data ransfer from different filegroups..
glnprvn 2009년 11월 24일 화요일 오전 6:14 - 3150

Using collation for international languag other than English
Manrippo 2009년 11월 7일 토요일 오후 10:16 - 033

Desktops are working great using OLE DB, but how do you connect SQL Server 2005 to MS Access on Tablet PCs used in the field?
Kraftsmanship 2009년 11월 24일 화요일 오후 6:19 - 124302

Damn this (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
freddyccix 2008년 10월 27일 월요일 오후 7:44 - 9222

Can't run SSIS package from a batch file
Steve Hempen 2009년 11월 3일 화요일 오후 10:05 - 3106

How to optimize mysql subquery performance?
Add-On 2009년 11월 23일 월요일 오전 6:52

