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 know nothing about isql and data sources, but the errors are pretty clear:

Find out how to install the missing file. An internet search might help.
The isql command requires a DSN, which you don't provide.

the library file is there . i don't understand why it's saying lib file not found

drwxr-xr-x. 2 informix informix 4096 Sep 25 12:43 .
drwxr-xr-x. 7 informix informix 4096 Sep 24 17:09 ..
-rwxr-xr-x. 3 informix informix 1707672 Jun 8 2017 iclis09b.so
-rwxrwxrwx. 3 informix informix 1739547 Jun 8 2017 iclit09b.so
-rwxr-xr-x. 2 informix informix 27830 Jun 8 2017 idmrs09a.so
-rw-r--r--. 2 informix informix 2549112 Jun 8 2017 libcli.a
-rw-r--r--. 2 informix informix 24208 Jun 8 2017 libdmr.a
-rw-r--r--. 2 informix informix 2549112 Jun 8 2017 libifcli.a
-rwxr-xr-x. 3 informix informix 1707672 Jun 8 2017 libifcli.so
-rw-r--r--. 2 informix informix 24208 Jun 8 2017 libifdmr.a
-rwxr-xr-x. 2 informix informix 27830 Jun 8 2017 libifdmr.so
-rwxr-xr-x. 3 informix informix 1707672 Jun 8 2017 libixcli.so
-rwxrwxrwx. 3 informix informix 1739547 Jun 8 2017 libtcli.so
-rw-r--r--. 1 informix informix 2551356 Jun 8 2017 libthcli.a
-rwxrwxrwx. 3 informix informix 1739547 Jun 8 2017 libthcli.so

/opt/IBM/csdk/4.10/lib/cli

I don't know either. Perhaps it's not a shared library? Or one of the pathname components /opt/IBM etc is not accessible to the program?

Please use code tags when posting output.

It's not clear where you're trying to connect from.

You do understand that the second command is simply incomplete? You didn't supply a DSN, so the command failed.

What are the permissions of the /opt/IBM/csdk/4.10/lib/cli directory?
Is the database to which you're trying to connect running?

A search for yields a lot of possibly useful information. Most talk about an incorrectly installed driver.

Did you do the search berndbausch suggested?

Try to add in ldcache your library:

IMPORTANT!!! - Take note of ">>" (double greater than character). It means to append an entry after the last line. Mistakenly using ">", will replace the entire contents.