OPENDATASOURCE error about "linked server"

• davidsalazar01

  SSCarpal Tunnel

  Points: 4072

  More actions

  April 7, 2008 at 9:52 am

  #188970

  Hello Master DBA'a/DB developers!

  I have a developer that is running this code the local server below and it keeps throwing the error message listed herein. Can anybody throw me a bone on this one? Thanks! 🙂

  SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=CYN-DB1;User ID=myuser;Password=mypassword).Vimas.dbo.accountDebits

  Or

  UPDATE OPENDATASOURCE('SQLOLEDB','Data Sour……

  Getting error below:

  Cannot create an instance of OLE DB provider "MSDASC" for linked server "(null)".

• damian.green-602250

  SSC Rookie

  Points: 40

  More actions

  May 29, 2008 at 3:11 am

  #821641

  You will find the fix/workaround that worked for me here

  opendatasource error

• Sachin Jain-225918

  SSC Journeyman

  Points: 78

  More actions

  November 29, 2010 at 11:28 pm

  #1256606

  Additionally you can try to verify the Account name under which your SQL server service is running.

  In my case, on Dev server, the Service was running under Local system account while on Test server it was running under NT Authority.

  Once i set the SQL service to run under Local system, we could use OpenDataSource...