isql conn error
by adura from LinuxQuestions.org on (#4R4DM)
Hi,
I want to test dsn connection that i have already setup in server .
But it give me an error below :
isql Infdrv1 acct acct@123 -v
[01000][unixODBC][Driver Manager]Can't open lib '/opt/IBM/csdk/4.10/lib/cli/iclit09b.so' : file not found
isql -v
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
Below i give what i has setup :
odbcinst -q -s
[Infdrv1]
[ODBC]
odbcinst -q -d
[PostgreSQL]
[MySQL]
strace -e trace=open isql Infdrv1 2>&1 | grep odbc.ini
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY)
Can someone please help me..urgent please


I want to test dsn connection that i have already setup in server .
But it give me an error below :
isql Infdrv1 acct acct@123 -v
[01000][unixODBC][Driver Manager]Can't open lib '/opt/IBM/csdk/4.10/lib/cli/iclit09b.so' : file not found
isql -v
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
Below i give what i has setup :
odbcinst -q -s
[Infdrv1]
[ODBC]
odbcinst -q -d
[PostgreSQL]
[MySQL]
strace -e trace=open isql Infdrv1 2>&1 | grep odbc.ini
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY) = 3
open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/etc/odbc.ini", O_RDONLY)
Can someone please help me..urgent please