SQLOLEDB Connection String to SQL2005 DB.

• megan.howes

  SSC Journeyman

  Points: 86

  More actions

  May 6, 2008 at 2:11 pm

  #182024

  Hi,

  I am new to SQL so this may be a lack of understanding on how things work.

  The below batch file fails:

  start \\emailsignature2\NETLOGON\sign.exe Provider=sqloledb;Data Source=EMAILSIGNATURE2;Initial Catalog=eMailSignatures;User Id=Standard_User;Password=******;

  However if I use Provider=SQLNCLI the batch file works which is great but I'm not keen on having to install sql native client on all the domain computers.

  Can someone confirm if sqloledb can be used to connect to sql2005 db and if so some ideas on why it's not connecting.

  Any tips much appreciated.

  Thanks

  Megan.

• SQL Dude-467553

  Hall of Fame

  Points: 3895

  More actions

  May 9, 2008 at 11:39 am

  #813263

  Why do you not like the SQL Native Client? It is actually just the updated version of the MDAC dll's for OLE DB and ODBC in one DLL. Here is a great Microsoft BLOG talking about the Native Client Library.

  http://blogs.msdn.com/sqlnativeclient/archive/2006/09/27/774282.aspx

• megan.howes

  SSC Journeyman

  Points: 86

  More actions

  May 11, 2008 at 2:08 pm

  #813570

  Hi,

  Absolutely nothing again sql native client. I just don't want to have to deploy it if it's not necessary. Turned out my connection string was wrong and sqloledb is now working.

  Thanks for your help.

• jh-811016

  SSC Rookie

  Points: 49

  More actions

  November 13, 2008 at 8:34 am

  #898141

  Hi Megan, in what way was your connection string incorrect?

  I have the same problem. Someone had reinstalled SQL 2005 without my knowledge. Subsequently, connections did not work until I found reference to SQLNCLI.