SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 09:16 PM
| ||||
| ||||
 Informix SE 6.02 and ODBC Is it possible to connect to Informix SE 6.02 on Unix via ODBC or ADO? If so, how? I've downloaded the IBM Informix Client SDK but don't know what port # to use. The services file does not have the sqlexec service listed in it. Thanks. -- _________________________________________ Don Gollahon dlgllhn@InHisStepsSoftware.com ICQ#: 115831669 "What in Eternity does it matter?" _________________________________________      |
|
04-19-2008, 09:16 PM
| |||
| |||
| Re: Informix SE 6.02 and ODBC Don Gollahon wrote: > Is it possible to connect to Informix SE 6.02 on Unix via ODBC or ADO? If > so, how? I've downloaded the IBM Informix Client SDK but don't know what > port # to use. The services file does not have the sqlexec service listed > in it. Sort of, maybe, but you shouldn't. 6.02 is pretty archaic. You'd have to run the sqlexecd program (from $INFORMIXDIR/lib). You'd have to configure which port it uses, either by adding sqlexec to /etc/services or by using some service name that is not in use but is in /etc/services. I'm pretty much assuming that your client code is on an M$ platform so you need to use a network connection - if it is also on Unix, then you don't have to use a network connection or sqlexecd but you can use the seipcpip connection type in the sqlhosts file and sqlexec in the fourth column indicates the executable to use. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ |
|
04-19-2008, 09:17 PM
| ||||
| ||||
| Re: Informix SE 6.02 and ODBC "Jonathan Leffler" <jleffler@earthlink.net> wrote in message news  Gmkc.19$fh4.0@newsread1.news.pas.earthlink.n et...> Don Gollahon wrote: > > Is it possible to connect to Informix SE 6.02 on Unix via ODBC or ADO? If > > so, how? I've downloaded the IBM Informix Client SDK but don't know what > > port # to use. The services file does not have the sqlexec service listed > > in it. > > Sort of, maybe, but you shouldn't. 6.02 is pretty archaic. > > You'd have to run the sqlexecd program (from $INFORMIXDIR/lib). You'd > have to configure which port it uses, either by adding sqlexec to > /etc/services or by using some service name that is not in use but is > in /etc/services. I'm pretty much assuming that your client code is > on an M$ platform so you need to use a network connection - if it is All code and development is on AIX right now. I want to try accessing by ODBC so Visio can read the table structures and do some diagraming to prepare for a rewrite. They have Informix 7.x (not sure which) but have not installed it. Don't know why. I just started working for them. They said it was on "tape" and the tape was bad. Will try to get them to download the update from the web. Anyway, want to rewrite their app in a GUI of some sort. I'm very much in favor of using Borland Delphi. But may go with something else. Part of the app will be rewritten for web access as well. > also on Unix, then you don't have to use a network connection or > sqlexecd but you can use the seipcpip connection type in the sqlhosts > file and sqlexec in the fourth column indicates the executable to use. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/ > Thanks. -- _________________________________________ Don Gollahon dlgllhn@InHisStepsSoftware.com ICQ#: 115831669 "What in Eternity does it matter?" _________________________________________ |
Linear Mode
