Linking a 64-bit server to a 32-bit server

• dgermundson

  Hall of Fame

  Points: 3175

  More actions

  July 9, 2004 at 8:05 am

  #83309

  We just installed the 64-bit version of sql on a new server.  We will use this for production.  However, we still want to use the 32-bit version for our supporting environments.  I'm able to link the 2 servers using EM. However, when I run a query (using QA) from the 64 to the 32-bit server I get this error.

  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:   ].

  Any help would be appreciated.

  Darren

  
  Darren
  

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 9, 2004 at 9:42 am

  #514114

  Try to reinstall the 64-bit version of MDAC 2.8 which comes with the 64-bit version of Windows Server 2003.

  I will install 64-bit SQL Server soon and see whether I could reproduce your problem.