Howdy,
I am trying to create a linked server on a SQL 2008 64-bit server. Using the SAGE ERP 100 64-bit ODBC. I want to link some of my MAS tables with SAGE CRM.
The Linked server is setup to not use a security context.
The query reads like
Select * from openquery(odbc_mas, 'Select * from AR_Customer')
I get the following error message
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "odbc_mas" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "odbc_mas".
This exact same setup works fine in a complete 32-bit environment.
Thanks much Mark