What does "DSN Migrate" in CSDK/Connect do?
Posted in 2006
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion
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
Hi Richard, Hope this link will help. http://www-306.ibm.com/software/data/informix/pubs/library/notes/relnotes/sdk230tc1.html 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