I am working on a c# application that was originally developed using the provider SQLNCLI11. Now the client is requesting to use the SQLOLEDB.1 provider. The development environment sql server is running locally and the sql server name is (LocalDb)\v11.0 using Integrated Security SSPI When the provider is SQLNCLI11, everything seems to work properly. When changed to SQLOLEDB, I receive the following error
[DBNETLIB] COnnectionOpen (Connect()).] SQL Server does not exist or access denied.
My connection string is:
Provider=SQLNCLI11;Data Source=(LocalDb)\v11.0;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=testdbname
Any idea why I am receiving this error when the provider is set to SQLOLEDB?