openRowSet returning " Could not create an instance of OLE DB provider 'SQLOLEDB'. "
Posted on 2004-04-13
i am migrating a mssql7 db on nt4 to a mssql7 database on win2k.
on the new server there is an openrowset query returning " Could not create an instance of OLE DB provider 'SQLOLEDB'. "
FROM OPENROWSET ( 'SQLOLEDB', 'GROVER';'uid';'pswd', 'stored procedure' ) AS Hierarchy,
FH_Media_Cat_213 AS Media_Ref WHERE Hierarchy.V_ID = 213 AND Hierarchy.H_ID = Media_Ref.Cat_ID
this query works fine on the old server, but for some reason doesn't on the new one. i have added grover to the system odbc datasources with no change.