I'm trying to set up an OLE DB based Linked Server on a SQL Server 2005 machine (SQL Server 2005 64-bit running on Windows Server 2003 64-bit). to access DB@ on an AS400 via the IBM Client Access drivers (V5R4). I can't get the Linked Server to work, and I can't find any good information on the error anywhere online.
I can get an ODBC based Linked Server to work, but I get the following error with the Managed (.Net) providers:
Cannot initialize the data source object of OLE DB provider "IBMDASQL" for linked server "DB2400"
As you can see form the error, I am trying to get the IBMDASQL data provider to connect, but I keep getting the error.
Does anyone know how to get this to work?