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.
Annunci
SQL Server JDBC Driver v2.0 is now available
Jimmy Wu - MSFT martedì 27 gennaio 2009 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 lunedì 2 novembre 2009 19.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 LehmanMSFTmartedì 16 dicembre 2008 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
Filtro e ordinamentoUsa queste opzioni per ridurre l'elenco delle discussioni.
- 06831
Guidelines when posting JDBC related questions
Jimmy Wu - MSFT sabato 2 agosto 2008 0.44 - 014165
Steps to troubleshoot SQL connectivity issues
Xinwei Hong - MSFT mercoledì 30 aprile 2008 16.40 - 495
Native C++ SQL Access
Davewolfs martedì 12 gennaio 2010 3.50 - 184
odbc administrator system error code 193
Susan Van Atta martedì 12 gennaio 2010 17.20 - 168
A network-related or instance-specific error occurred while establishing a SQL connection
Anks_moss2007 19 ore 6 minuti fa - 149
sqlcmd date column returns 16 characters instead of 10 characters
JMcHenry 6 ore 37 minuti fa - 031
Access 2003 Front-End SQL 2000 Back-end Issue
Routergal 1 ora 34 minuti fa - 17696
SQL Server 2008 geometry maximum row size of 8060?
Andy Lawrie giovedì 24 dicembre 2009 11.50 - 157
SQL Server 2005 30-second timeout problem
MarcusVowell 7 ore 7 minuti fa - 160
about remote connection
rajsjd_84 11 ore 28 minuti fa - 059
Permissions problem with AD LDS linked server
Frans Knibbe 9 ore 18 minuti fa - 7127
Installing SQL2000 after Installing .net 2005
Hariramprasath martedì 12 gennaio 2010 7.07 - 3402
OLE DB Streaming LOB data w/input parameters
Michael Bergamo giovedì 3 dicembre 2009 19.14 - 913984
Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only
PSinclair venerdì 10 febbraio 2006 16.04 - 387
need help to join 2 tables
Mandar Bansod martedì 12 gennaio 2010 13.12 - 3162
Windows authentication - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
VidhyaVijayaKumar sabato 9 gennaio 2010 17.57 - 1720601
Error :(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
SPPatel giovedì 1 marzo 2007 5.38 - 2114
Connecting to SQL Server 2000 (32bit) from Windows 7 (64bit)
epicnet martedì 12 gennaio 2010 0.40 - 23376
ODBC DSN Connections to SQL database work as Administrator but fail as all regular network users
ShelbyMeyer domenica 3 gennaio 2010 23.39 - 298
SQL Server Connectivity over a Public IP
V VICTOR lunedì 11 gennaio 2010 23.02