Oninit cdi / Archive
Talk to an expert →

Help setting up ODBC on AIX

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Networking & sqlhosts Configuration, Platform-Specific Issues

Erol Guven — — source: Informix-list mailing list archive (1991-1998)

I am trying to set up ODBC on AIX without any success. I wrote a test program that connects to the server which uses the CLI interface. And I am getting the following error message. "[Informix][Odbc Informix Driver]Data source name not found and no default driver specified." I am using the SQLConnect function and specify 'testdb' for DSN. my odbc.ini file looks like ... [testdb] Driver=/usr/local/informix/lib/cli/iclis09a.so Database=mytestdb Server=default_online ... I copied the odbc.ini to $HOME, $INFORMIXDIR, $INFORMIXDIR/etc just to be sure it will find the file somewhere. The corresponding entry in $INFORMIXDIR/etc/sqlhosts file is correctly set-up since I can connect with my ESQL test program. My database server version is INFORMIX-SE Version 7.12.UC1 and Client sdk version is INFORMIX-Client SDK Version 2.02.UC2. what am I missing? _________________________________________________________________________ Erol Guven Template Software, Inc. erol.guven@template.com 45365 Vintage Park Plaza, Suite 100 (703) 925-1447 Dulles, VA 20166

↪ replying to Erol Guven
Joe Blackman — — source: Informix-list mailing list archive (1991-1998)

Is that "odbc.ini", or ".odbc.ini"? Erol Guven wrote: > I am trying to set up ODBC on AIX without any success. > > I wrote a test program that connects to the server which uses the CLI > interface. And I am getting the following error message. > > "[Informix][Odbc Informix Driver]Data source name not found and no > default driver specified." > > I am using the SQLConnect function and specify 'testdb' for DSN. > > my odbc.ini file looks like > > ... > [testdb] > Driver=/usr/local/informix/lib/cli/iclis09a.so > Database=mytestdb > Server=default_online > ... > > I copied the odbc.ini to $HOME, $INFORMIXDIR, $INFORMIXDIR/etc just to > be sure it will find the file somewhere. > > The corresponding entry in $INFORMIXDIR/etc/sqlhosts file is correctly > set-up since I can connect with my ESQL test program. > > My database server version is INFORMIX-SE Version 7.12.UC1 > and Client sdk version is INFORMIX-Client SDK Version 2.02.UC2. > > what am I missing? > > _________________________________________________________________________ > Erol Guven Template Software, Inc. > erol.guven@template.com 45365 Vintage Park Plaza, Suite 100 > (703) 925-1447 Dulles, VA 20166

Glossary