Re: What does "DSN Migrate" in CSDK/Connect do?
Posted in 2006
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion
Hello Richard, It is a rather unfortunate thing that the DSNs created using the older version of CSDK are not removed once CSDK is uninstalled. You are right in saying that users have to manually remove the DSN that has been created before uninstalling CSDK or I-Connect. As for the DSN migrate utility - it was designed only for migrating from Intersolv DSNs to Informix DSN. It could have been tailored to migrate Informix DSN also between versions, but apparently that did not happen and is not functional through DSN migrate. Going forward though the issue of orphaned DSNs has been taken care of. Starting with CSDK2.90, whenever the users uninstall CSDK, the associated DSNs that were created will also be removed so that this problem is not seen, Until then, I guess we are going to have to live this problem. Thanks and Regards, Abhi Richard Spitz wrote: > Dear Informixers, > > at least the more recent versions of the Informix CSDK and Connect > for Windows contain a program called "DSN Migrate". I haven't been > able to find any documentation on this. The link the Start Menu says > "Migrates ODBC DSNs between CLI 2.8 and ODBC 3.3 formats", but there > is no further documentation or help file. > > Any pointers to the documentation about this migration utility? > > I'm asking because I came across a number of machines where a previous > version of I-Connect had been deinstalled and the newest I-Connect 2.90TC4 > installed. Now there are some DSNs pointing to Informix databases that > cannot even be removed because the old version is missing and no new > DSN of the same name can be configured because the old one is still > sitting around. And there are applications that need that DSN name... > > The only way to deal with Informix DSNs in an upgrade situation seems to > be to delete the DSN before deleting the old version of I-Connect and > then recreating the DSN after installation of the new version. Or is there > a method of migrating the DSN to the new version? I had hoped that "DSN > Migrate" might do this, but apparently it doesn't. > > "RTFM" answers welcome as long as they point to the FM to R ;-) > > Regards, Richard