We are in the process of migrating our SQL Server from version 7 to 2000 (also from NT Server to WS2003 on another domain/computer).
I added the ODBC data source and registered the linked server.
The strange thing is that while I can use openquery i QA to access the linked server, I get
Error 7399: OLE DB provider 'UNKNOWN' reported an error.
OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80004005: ].
in enterprise manager and DTS packages.
I have verified the ODBC connection and compared the registration with the existing (working) ones.
Does anybody have a clue to why this happens, and more importanly, how I can fix it?