Kbase P109708: Getting an error -211019 when connecting to a database using SQL-92, ODBC or JDBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/07/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1X
OpenEdge 10.0X
SYMPTOM(s):
SQL-92 ODBC JDBC connections are failing to connect to a database
Database is enabled for 4GL security
4GL connection works fine
Getting an error -211019 when connecting to a database using SQL-92, ODBC or JDBC
Connection error reads
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-211019
[JDBC Progress Driver]:-211019
Any _file record-length of > 9500 will cause that error i.e. char extents of 9999
Also if there is a huge number of user stored in _user table
Or if table _can-write, _can-load, _can-dump, _can-read permissions are set for all the users in _user table
CAUSE:
Bug# 20050915-013
FIX:
Upgrade to 10.0B04 or higher ,10.1A01 or higher ,10.1B, or upgrade to 9.1E03 or higher