We have installed full oracle 19.1 client on linux /var/opt/oracle/client2
Also installed and configured ODBC . here is the entry in odbcinst.ini:
[Oracle_ODBC_Driver_in_ora19c]
Description=Oracle 19c ODBC driver.
Driver=/var/opt/oracle/client2/lib/libsqora.so.19.1
Setup=
FileUsage=
CPTimeout=
CPReuse=
UsageCount=2
Here is odbc.ini
[Wilson_prd]
Description = Wilson
Driver = Oracle_ODBC_Driver_in_ora19c
DSN = wilson.myorg.com
ServerName = wilson.myorg.com
UserId = wilson_read
Here is tnsnames.ora:
wilson.myorg.com =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = myOracledbServer.net) (PORT = 6016))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = wilson.myorg.com)))
Here is LD_LIBRARY_PATH
$ echo $LD_LIBRARY_PATH
/var/opt/oracle/client2/lib/
But when I try and test the odbc i get following error:
$ isql -v Wilson_prd
[01000][unixODBC][Driver Manager]Can't open lib '/var/opt/oracle/client2/lib/libsqora.so.19.1' : file not found
[ISQL]ERROR: Could not SQLConnect
Any Ideas????