|
Subject:
|
Using DTS for Informix to SQL
|
|
Posted By:
|
bdoran
|
Post Date:
|
6/26/2003 12:01:20 PM
|
I am having a bugger of a driver issue when trying to get to an Informix Database through DTS. Does anyone have experience with this?
Some Facts:
1) I am using the IBM Informix CSDK latest version which installs the 3.81 informix ODBC driver
2) I get a valid connection to the database when I set up a DSN in ODBC Manager.
3) The DTS to Informix works on the server(Win2k) and on my desktop (XP) but NOT on another developer's machine (XP). While I can get a valid connection to the database on this machine in the DSN setup, I cannot get the DTS to "read" this properly.
The error I get in setting up the DTS Connection is "unable to load the translation DLL"
I have uninstalled and reinstalled the informix driver by uninstalling the Informix CSDK.
Very freaky behavior because sometimes I can get the DTS to start running and not error out with the DLL message but it runs on forever and I eventually need to kill it.
Any thoughts on how to move forward here?
Thanks much
-- Bridget
|
|
Reply By:
|
cdinh
|
Reply Date:
|
11/19/2004 2:26:07 PM
|
1) Check the INFORMIXDIR varable in the setnet32
(i.e. INFORMIXDIR=C:\Program Files\Informix\Client-SDK\)
Make sure that this is the actual physical location where the product is installed on your hard drive.
2) Check the hosts.equiv (in c:\winnt\system32\drivers\etc directory) on your workstation(ws) and the server
make sure the servername or the ip address are matched.
3) check the services file on both ws and the server
to ensure the port number are the same
4) MAKE SURE THERE IS ONLY ONE bin/setnet32 file on the ws.
good luck.
Chi
|
