January 3, 2004 at 7:36 am
Hi, I need help, I tried to create link server between 64bit SQL Server to read data from 32bit SQL Server. Everything seem normal but when i tried to get data i get this error :
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005: ].
When i tried to get data from 64 bit from 32bit SQL Server everything are normal.
Does anyone have any ideas what cause this error? Anything will be appriciated, thanks
rgds,
Bobie
January 6, 2004 at 8:00 am
This was removed by the editor as SPAM
January 6, 2004 at 11:02 am
Im jealous that you have a 64bit machine to play with! I think I'd hit PSS on this one.
September 30, 2005 at 11:18 am
The fix is to install the file Instcat.sql from the SQL64bit CD on the 32bit server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply