I'm hoping someone will be able to help me here... I'm trying to create a linked server with an Ingres database as the remote server with a database called fish and SQLServer as the local server with a database called master.
Not matter what I do, I keep on getting this error:
ODBC Driver Load Error: neither oiapi.dll nor iiapi.dll could be loaded. LoadLibrary error code = 126
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Specified driver could not be loaded due to system error 1114 (Ingres)].
OLE DB error trace [OLE/DB provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
this is just from doing something simple like "select * from operation" (where operation is a table on the remote server in the fish database)