Sql-server – Cannot connect with OLE DB

oledbsql serversql-server-2012

OLE DB connection…

Can anyone suggest me on this.

  • Authentication with windows security works in 2012-2005

"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;
Initial Catalog=TESTDB;Isolation Level = ReadUncommitted;Data Source=SERVER"

  • In 2012 this gives me an error in 2012

Provider=SQLNCLI11;Persist Security Info=False;Initial Catalog=TESTDB;Data Source=SERVER;Language=us_english;User Id=AA;Password=SSS

error conn.open
Property access must assign to the property or use its value.
Sql client not registered

Best Answer

The answer is right there on the last line of the error message:

Sql client not registered

You need to install the SQL Server Client Library on the machine in question.

You can obtain that package from http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

Also, Isolation Level = ReadUncommitted may be problematic if you don't fully understand the implications of ReadUncommitted See http://msdn.microsoft.com/en-us/library/ms173763.aspx

Related Question