ODBC Setup
Jason Pancake asked where to find the Service Name and Server Name that the ODBC driver setup requires. Roman Sapia pointed to the sqlhosts file under INFORMIXDIR/etc. Jason then got system error 126 loading the MERANT 3.50 driver (Informix 7.x on AIX, NT client). Randy Hao suggested checking the TCP/IP port in the services file; Richard Spitz suggested setting INFORMIXDIR and PATH. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
ODBC Driver Setup is asking for "Service Name" and "Server Name". Anyone know where I can find these settings and how to get there? Thanks for your help. -- Jason Pancake Network Services Specialist III University of Georgia School of Law jpancake@arches.uga.edu (706)542-1941 --- McBride fell 12 stories, hitting the pavement like a Hefty Bag filled with vegetable soup. (Paul Sabourin, Silver Spring)
> ODBC Driver Setup is asking for "Service Name" and "Server Name". Anyone > know where I can find these settings and how to get there? Hi! Look in you $INFORMIXDIR/etc/sqlhosts, must looks like this: Server_name Protocol_name Hosts Service_name -- Rom'n Sapia roman_news@decker-indelqui.com.ar Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Thank you for the info. Now my problem is that I get an error stating "Specified driver could not be loaded due to system error 126 (MERANT 3.50 32-BIT INFORMIX)" Does anyone know how to fix this? Thanks, Jason Roman Sapia <romansapia@my-deja.com> wrote in message news:7n2ge7$4rl$1@nnrp1.deja.com... > > > ODBC Driver Setup is asking for "Service Name" and "Server Name". > Anyone > > know where I can find these settings and how to get there? > > Hi! > > Look in you $INFORMIXDIR/etc/sqlhosts, must looks like this: > > Server_name Protocol_name Hosts Service_name > > > -- > Rom'n Sapia > roman_news@decker-indelqui.com.ar > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.
You may need check the TCP/IP port are match with each other(client and server). Take a look service file (c:\\windows\\services) to see the port is available or not. If not, you need add into it. Randy Jason Pancake wrote in message <7n2jke$62g$1@cronkite.cc.uga.edu>... >Thank you for the info. Now my problem is that I get an error stating >"Specified driver could not be loaded due to system error 126 (MERANT 3.50 >32-BIT INFORMIX)" Does anyone know how to fix this? > >Thanks, >Jason > >Roman Sapia <romansapia@my-deja.com> wrote in message >news:7n2ge7$4rl$1@nnrp1.deja.com... >> >> > ODBC Driver Setup is asking for "Service Name" and "Server Name". >> Anyone >> > know where I can find these settings and how to get there? >> >> Hi! >> >> Look in you $INFORMIXDIR/etc/sqlhosts, must looks like this: >> >> Server_name Protocol_name Hosts Service_name >> >> >> -- >> Rom'n Sapia >> roman_news@decker-indelqui.com.ar >> >> >> Sent via Deja.com http://www.deja.com/ >> Share what you know. Learn what you don't. > >
I should probably mention that I'm running 7.x on AIX - IBM RS 6000 and I would like to setup the ODBC driver on my NT Workstation box in order to write and play with VB front end. Jason Pancake <jpancake@arches.uga.edu> wrote in message news:7n2855$nf6$1@cronkite.cc.uga.edu... > ODBC Driver Setup is asking for "Service Name" and "Server Name". Anyone > know where I can find these settings and how to get there? > > Thanks for your help. > > -- > Jason Pancake > Network Services Specialist III > University of Georgia > School of Law > jpancake@arches.uga.edu > (706)542-1941 > > --- > McBride fell 12 stories, hitting the pavement like a Hefty Bag > filled with vegetable soup. (Paul Sabourin, Silver Spring) > > >
Jason Pancake wrote: > Thank you for the info. Now my problem is that I get an error stating > "Specified driver could not be loaded due to system error 126 (MERANT 3.50 > 32-BIT INFORMIX)" Have you set the environment variable "INFORMIXDIR"? You can do this with the "setnet32"-Utility (does that still come with version 3.50?) or through the NT "My Computer/Properties" dialog. Also make sure that $INFORMIXDIR\\bin is in your PATH. HTH, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 <-- NEW!!! | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+