import informix data in other database appl

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

deven luk — Mon, 3 Apr 2000 16:32:23 +0200 — source: Informix-list mailing list archive (1991-1998)

We have an application develloped by one of our collaborators in informix. The person is now heavily ill and as he is the only one who can use the application we are stuck. As we want to use the date, without changing anything to the program, i would like to retrieve the data in an ordinary access file. Is this possible without special odbc drivers ? If not where can i find these drivers ? Thanks for your help devenluk@hotmail.com

↪ replying to deven luk

Rudy Fernandes — Mon, 03 Apr 2000 15:40:52 -0400 — source: Informix-list mailing list archive (1991-1998)

deven luk wrote: > We have an application develloped by one of our collaborators in informix. > The person is now heavily ill and as he is the only one who can use the > application we are stuck. As we want to use the date, without changing > anything to the program, i would like to retrieve the data in an ordinary > access file. > Is this possible without special odbc drivers ? If not where can i find > these drivers ? > > Thanks for your help > > devenluk@hotmail.com The ODBC driver is part of the Client SDK kit available free from http://www.intraware.com. Rudy

↪ replying to deven luk

Leo Monroy — Thu, 13 Apr 2000 15:11:45 -0500 — source: Informix-list mailing list archive (1991-1998)

You can unload the data into and ascii file by using the Informix unload command: unload to "<path/filename.unl>" select * from <tablename> to load the data back into the table type the following: load from "<path/filename.unl>" insert into <tablename> Good luck deven luk wrote: > We have an application develloped by one of our collaborators in informix. > The person is now heavily ill and as he is the only one who can use the > application we are stuck. As we want to use the date, without changing > anything to the program, i would like to retrieve the data in an ordinary > access file. > Is this possible without special odbc drivers ? If not where can i find > these drivers ? > > Thanks for your help > > devenluk@hotmail.com

↪ replying to Leo Monroy

Imran Hussain — Thu, 20 Apr 2000 16:21:34 GMT — source: Informix-list mailing list archive (1991-1998)

Try WinSQL Professional at http://www.indus-soft.com/winsql Leo Monroy wrote: > You can unload the data into and ascii file by using the Informix unload > command: > > unload to "<path/filename.unl>" select * from <tablename>> > to load the data back into the table type the following: > > load from "<path/filename.unl>" insert into <tablename>> > Good luck > > deven luk wrote: > > > We have an application develloped by one of our collaborators in informix. > > The person is now heavily ill and as he is the only one who can use the > > application we are stuck. As we want to use the date, without changing > > anything to the program, i would like to retrieve the data in an ordinary > > access file. > > Is this possible without special odbc drivers ? If not where can i find > > these drivers ? > > > > Thanks for your help > > > > devenluk@hotmail.com -- ===================================================================== Imran Hussain imranh@imranweb.com For FREE Software visit http://www.imranweb.com/freesoft =====================================================================