SQL Server Native Client 10.0 OLE DB Provider connection strings

Connects to

SQL Server 2008

Problems connecting?
Get answer in the SQL Server 2008 Q & A forum

SQL Server 2005

SQL Server 2000

SQL Server 7.0

SQL Azure

  • Standard

    Microsoft does not announce support for OLE DB connections to Azure and there are limitations. Some required OLE DB schema rowsets are not available from an Azure connection, and some properties that identify features in SQL Server are not adjusted to represent SQL Azure limitations. For most common connect/query/update tasks it seems to work fine.

    Provider=SQLNCLI10;Password=myPassword;User ID=[username]@[servername];
    Initial Catalog
    =databasename;Data Source=tcp:[servername].database.windows.net;
OLE DB ProviderProvider=SQLNCLI10Info and provider downloads

Articlesread all »

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.