Kbase 21694: SQL-92: Common Errors With ODBC On Linux
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/30/2009 |
|
Status: Verified
GOAL:
What are some common error messages that occur using Progress 9.1x SQL-92 ODBC driver on Linux Red Hat 7.2.
FACT(s) (Environment):
RedHat Linux 7.2
Progress 9.1C
FIX:
The error messages and solutions are:
-- SQLState : 60
Message : [MERANT][ODBC 20101 driver]6013
ErrorCode: 0
Solutions:
- The environment variable ODBCINI is not set. It should point to the file odbc.ini you have defined.
- Check the LogonID/Password keywords.
They have to be specified in the ODBC.INI file even if there is no user created in the database.
-- SQLState : S1000
Message : < None >
ErrorCode: 80
Solution:
Check the InstallDir keyword is correct:
[ODBC]
InstallDir=<$DLC>/odbc
This error appears when the driver's path is not specified in the Driver keyword and the InstallDir keyword is not correct.
Remark:
It is not necessary to specify the path of the pgpro915.so library in the Driver keyword as long as the InstallDir keyword is correct. However some ODBC tool (like ISQL) requires it.
-- SQLState : IM003
Message : Specified driver could not be loaded
ErrorCode: 80
Solution:
Check the driver's path as well as its name specified in the Driver keyword are correct:
[<Your DSN>]
Driver=<dlc>/odbc/pgpro915.so