The error 999 shows up with several error messages. For example:
When we connect to PostgreSQL using ODBC but we forget to fill insqlca.DBMS, the application log has 999 without an errortext:
fnv_connect: -1
DBHandle is 0
Setting up n_tr DBMS: DBParm: CacheName='pgsqlODBC12' Autocommit: false connect using i_tr... dberror event triggered on n_tr code: 999 sqlerrortext:
sqlsyntax: SQLErrText: sqldbcode: 999 sqlcode: -1
When we try to connect to ODBC, but we set sqlca.DBMS incorrectly to JDBC, the code is 999, but there is a message "sqlerrortext: Java Exception : Fatal Error. Unable to initialize DatabaseMetaData class."
fnv_connect: -1
DBHandle is 0 Setting up n_tr
DBMS: JDBC
DBParm: CacheName='pgsqlODBC12' Autocommit: false connect using i_tr... dberror event triggered on n_tr code: 999
When connecting to ODBC using the correct sqlca.DBMS=ODBC, we also get the 999, but with the errortext about the invalid handle.
fnv_connect: -1
DBHandle is 0 Setting up n_tr DBMS: ODBC DBParm: CacheName='pgsqlODBC12' Autocommit: false connect using i_tr... dberror event triggered on n_tr code: 999 sqlerrortext: An invalid handle was passed in a call to the database driver. sqlsyntax: SQLErrText: An invalid handle was passed in a call to the database driver. sqldbcode: 999 sqlcode: -1
Unfortunately, it seems that the error 999 can have several causes.
On the EAServer side we have tried all kind of things. If the connection log from the driver looks okay I am afraid we have ran out of ideas.
