IDS & SQL Server Interconnectivity
Posted in 1999
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues
Hi, I work for Hewlett-Packard and am currently involved in a project to investigate ways of enabling data replication between heterogeneous platforms and database environments. Our core backend is provided by IDS 7.30.UC6 running on HP-UX 10.2. I am trying to replicate into, and potentially out of, SQL Server 7 using ODBC technology. I have SQL Server 7 and the Informix SDK2.2 drivers installed on an NT4 box. I am trying to create a Linked Server from the SQL Management console. This relies on two levels of communication, OLE DB and ODBC. On setting up the connection I get the following errors in the Query Analyzer window with SQL Server: A. Using Intersolv 3.11 drivers for ODBC Connection Server: Msg 7399, Level 16, State 1 OLE DB provider 'MSDASQL' reported an error. A provider-specific error occurred. [OLE/DB provider returned message: Specified driver could not be loaded due to system error 126 (INTERSOLV 3.11 32-BIT INFORMIX 9).] B. Using Informix 2.80 drivers for ODBC Connection Server: Msg 7399, Level 16, State 1 OLE DB provider 'MSDASQL' reported an error. A provider-specific error occurred. [OLE/DB provider returned message: [Informix][Odbc Informix Driver]Unable to load translation DLL.] [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed] Error B is also seen when trying to use MS Query (i.e. Using a File DSN to access the System DSN). I should point out that both ODBC connections work with other tools i.e. Tools that work at the System/User DSN level - Not File DSN. SQL Server 7 recommends that the OLE DB provider for ODBC is MSDASQL. The OLE DB connection is setup to run at the System DSN level but the above errors result. Has anyone seen these problems before and do you know of any solutions? Regards, Conor Crowley.