July 11, 2003 at 1:26 pm
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
July 11, 2003 at 3:21 pm
Something wrong with the driver - cocreate error means probably a bad version of a dll or just plain missing. Maybe reinstall MDAC.
Andy
July 14, 2003 at 10:18 am
Andy,
I installed MDAC 2.7 on my PC, but still got the same error. Is there anything elso I can try?
Thanks
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply