RESOLVED: [dba-SQLServer]Using DTS for Informix to SQL

Hello Bridget,

I have just read your first email, so sorry that you got little responses.

I am currently working on DTS, but I have never used imformix and I have
only used DTS for text file to db transfers.

Sorry that you got no replies, but thanks for posting the answer also.

I take it that your family are from my part of the world

Mark Breen
Ireland



----- Original Message ----- 
From: "Bridget Doran" <bdoran at cce.umn.edu>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, June 26, 2003 8:00 PM
Subject: RESOLVED: [dba-SQLServer]Using DTS for Informix to SQL


> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>