[unixODBC-support] ISQL Error on Connect to DB2

Martin J. Evans martin.evans at easysoft.com
Fri Mar 27 19:46:51 GMT 2009


Ralph Hershkowitz/NYLIM wrote:
> I am able to connect to remote db NYL using db2connect however isql doesn;t
> seem to work

You appear to have hijacked someone elses thread - please start a new 
one in future.

> $ isql NYL nylife xyz
> [ISQL]ERROR: Could not SQLConnect
> 

add a -v to that isql line and what does it output:

$ isql -v NYL nylife xyz


> oracle at pnyorclux83:/usr/local/etc> more odbcinst.ini
> [DB2]
> Description     = DB2 Driver
> Driver          = /opt/home1/db2inst1/sqllib/lib/libdb2.so
> FileUsage       = 1
> DontDLClose     = 1
> 
> oracle at pnyorclux83:/usr/local/etc> more odbc.ini
> [NYL]
> Description     = Test to DB2
> Driver          = DB2
> Database        = NYL
> 
> 
> Any ideas?

On the face of it look ok but -v will tell us more.

Martin




More information about the unixODBC-support mailing list