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 

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.