Kbase P126712: Unable to establish ODBC connection from application to Progress database using SQL-92 interface
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/2/2007 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
OpenEdge 10.x
SYMPTOM(s):
Application runs on the same server as the Progress database.
Application needs to simultaneously connect to 2 different databases: Progress and 3rd party database
Unable to establish ODBC connection from application to Progress database using SQL-92 interface
UDA-SQL-0107 A general exception has occured during the operation "attach"
[iODBC][Driver Manager]libpgicu22.so: cannot open shared object file: No such file or directory
[iODBC][Driver Manager]Specified driver could not be loaded
LD_LIBRARY_PATH environment variable contains path to 3rd party ODBC libraries prior to the path to the Progress libraries:
LD_LIBRARY_PATH = /dr01/<3rd party database>/apps/odbc/lib:/dr01/progress/dlc101b/odbc/lib
CAUSE:
Third party database library path in LD_LIBRARY_PATH were preventing the Progress libaries to be picked up by application.
There was a naming conflict: both Progress and 3rd party database are using the same name for the ODBC shared library: libodbc.so
FIX:
Removing the 3rd party section from the LD_LIBRARY_PATH environment variable allows the connection to the Progress database to be made.