Friday, April 26, 2019

ODBC error 81 in SQLConnect

After installing Oracle Client 12.2.0.1 (32-bit) and Siebel IP17, one of the mandatory steps is to test connectivity to the Database using odbcsql command, like:

odbcsql /u <db_username> /p <db_password> /s <DSN_Name>

But I wasn't able to get it to work, instead I was facing the below error:

Logging into "SiebelInstall_DSN" as "SIEBEL" ...
ODBC error 81 in SQLConnect:
523 80
(native error 0).
Unable to login using specified ODBC parameters.

After some troubleshooting I was able to solve it after creating a symbolic reference for libclnst lib:

cd $ORACLE_HOME/lib
ln -s libclntsh.so.12.1 libclntsh.so






No comments:

Post a Comment