Bridget Doran
bdoran at cce.umn.edu
Thu Jun 26 14:00:25 CDT 2003
Looks like the interest is lacking on this one but just in case someone out there wonders.... This appears to be a classic DLL Hell scenario. I finally decided to uninstall and reinstall SQL Enterprise Manager on the machine which fixed the problem. I wish I would have thought of that sooner :) One caveat for other unsuspecting installers out there: When you get the DLL message on an uninstall to delete or not [Yes, Yes to All, No, No to All], realize this is a very tricky question! -----Original Message----- From: Bridget Doran Sent: Thursday, June 26, 2003 12:14 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]Using DTS for Informix to SQL Hello all -- 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 the problem 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? I was thinking I may need to reimage the machine from scratch. Not sure what else to do. Thanks much Bridget Bridget Doran ~~~ Office of Information Systems College of Continuing Education 612.626.8633 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com