I am trying to run a distributed queryfrom a 64 bit server to a 32 bit server ie.
select * from LinkedServer.Database.dbo.table
...I get the following message:
Server: Msg 7399, Level 16, State 1, Line 1
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 run the distributed query the other way (32 bit to 64 bit) it works fine. Any idea what is happening here?