Hi
I've have a Windows 2003 Server Enterprise Edition 32-bit with SQL Server 2005 installed and i'm trying to create a linked server to an ingres database. I've installed the ingres client tools and successfully set up a System DSN called ASH which is testing correctly.
I've then set up a linked server pointing to this DSN, however when I test the connection I get the following error
The OLE DB provider "MSDASQL" for linked server "ASH" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ASH".
OLE DB provider "MSDASQL" for linked server "ASH" returned message "[CA][Ingres 3.0 ODBC Driver][Ingres 3.0]The connection to the server has been aborted.".
Does anyone have any idea's?