Re: OLE DB error

• XuJohn

  Right there with Babe

  Points: 775

  More actions

  July 11, 2003 at 1:26 pm

  #161824

  Hi,

  I tried to run the following query against several remote SQL2K boxes,

  SELECT a.name

  FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=TestServer;UID=sa;PWD=pass',

  master.dbo.sysxlogins) AS a

  It worked on some boxes, while failed on the others. here is the error message I got:

  Server: Msg 7302, Level 16, State 1, Line 1

  Could not create an instance of OLE DB provider 'MSDASQL'.

  OLE DB error trace [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154].

  Any iders waht's wrong?

  Thanks in advance

  John

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 11, 2003 at 3:21 pm

  #465193

  Something wrong with the driver - cocreate error means probably a bad version of a dll or just plain missing. Maybe reinstall MDAC.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• XuJohn

  Right there with Babe

  Points: 775

  More actions

  July 14, 2003 at 10:18 am

  #465369

  Andy,

  I installed MDAC 2.7 on my PC, but still got the same error. Is there anything elso I can try?

  Thanks

  John