Welcome to MSDN Blogs Sign in | Join | Help

Updated connection string for OLEDB provider for SQL Server 2005

So I was playing around with an ASP.NET page connecting to SQL Server 2005 using the OleDB managed provider (not recommended BTW - if you're writing managed code against SQL Server 2005 you should be using the SqlClient), and my code, which used to go against older versions of SQL choked with an OleDbException. After some investigation, I found the answer - the Provider for SQL Server 2005 is SQLNCLI (for older versions it was SQLOLEDB).

Published Wednesday, March 02, 2005 1:11 PM by harisekhar

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Updated connection string for OLEDB provider for SQL Server 2005

Tuesday, April 25, 2006 8:17 AM by Reginald Jett
I am currently trying to connect an asp.net webform to SQL Server Developers Edition further info:
During Installation of SQL Server I chose a Domain user account over a local system account even though I only have a workgroup, no domain controller also chose Windows Authentication

I have M$ SQL Server 2000 Developers Edition
M$ Windows NT-5.1 (2600)
Product Ver. 8.00.760 (SP3)
Security Authentication – Windows Only
Start and run SQl Server in system administrator’s name .\Reginald

In Visual Studio under Server Explorer- under DataConnection when I right click on INEFFABLe.BobsSportingGoods.dbo and then choose properties:
(name)INEFFABLE.BobsSportingGoods.dbo
(Connection String) Provider= SQLOLEDB.1; Integrated Security=SSPI;Persist Security         Info=False;Intitial Catalog=BobsSportingGoods;Data Source=(local);

(Driver) M$ OLEDB Provider for SQL Server
(Server) INEFFABLE
(State) Connected
(Type) SQL Server 2000 Database
(User) dbo
Ihave tried different connection string and the errors that i am getting back is usually server does not exist or access denied

i know the server does exist so i am assuming that its an access denied problem could you tell me the proper install for SQl Developers Edition and a connection sring for C# and VB.Net.  I would surely appreciate your time and help.

Thanks, reggie
PS you can reach me at sorta_ineffable@msn.com

# re: Updated connection string for OLEDB provider for SQL Server 2005

Wednesday, October 25, 2006 1:11 AM by santhana krishnan

please tell me the connection String for SQL server 2005.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker