Connecting to SQL Server 2005

• imarchenko-236376

  SSCommitted

  Points: 1734

  More actions

  December 25, 2005 at 8:36 pm

  #111042

  Hello!

   

      I was wondering if I need to install something on the client in order to establish ODBC/OLEDB connection to SQL Server 2005. Currently, I have ADO 2.6 installed. Are there any changes in ODBC/OLEDB drivers for SQL Server 2005?

   

  Thanks,

  Igor

• December 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Emilio Baez

  SSC Enthusiast

  Points: 118

  More actions

  December 28, 2005 at 12:42 pm

  #611757

  Hi:  The OLEDB Provider for SQL Server 2005 is not "OLEDB" - Instead you should use SQLNCLI - Which stands for SQL Native Client, something like this

  Provider=SQLNCLI;Integrated Security=SSPI;Data Source= "servername or IP" ;Initial catalog=YourDatabase,

  Thanks,

  Emilio

  ---

  Kindest Regards,

  Emilio

• David Jansen-278311

  SSC Enthusiast

  Points: 121

  More actions

  January 2, 2006 at 11:51 am

  #612318

  Remember that MSSQL '05 does not allow remote connections by default. Use SQL SSAC to make your db accessible to remote clients.