Kbase P92497: SQL-92 access to database fails with Error -211019 after database is converted using conv89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 access to database fails with Error -211019.
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]-211019
Error: [JDBC Progress Driver]:-211019. (8933)
Databases created with Progress 9.1D works fine
Adding 4GL user " sysprogress " and using it for the SQL-92 connection does not solve the problem
CHANGE:
Database converted from Progress 8.x using conv89 utility
CAUSE:
Problem during proutil -C conv89 that prevented SQL-92 tables to load into the converted database.
FIX:
Load the SQL-92 tables manually to the database by executing the following steps:
1. Set Progress environment variable by running proenv script
2. Backup the database
3. Execute mkschema command using the following syntax:
mkschema -v <db-name>