Kbase P88423: Error (7519) after running 'Set Schema' statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/12/2008 |
|
Status: Verified
SYMPTOM(s):
Error (7519) running Delphi application with SQL statement
Table/View/Synonym not found (7519)
SET SCHEMA 'PUB' is being used
Connecting Delphi to Datadirect ODBC driver via DBEXPRESS
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.x
Windows
CHANGE:
Upgraded from 9.1C to 9.1D
CAUSE:
Some applications open extra connections if SQLGetInfo(SQL_ACTIVE_STATEMENTS) does not return 0, then the SET SCHEMA does not remain active to the other connections
FIX:
In order to resolve the issue you can apply one of the following workarounds:
1 - use the Registry editor: 'regedt32.exe'. (Improper use of this tool may corrupt your system).
If USER ODBC Data Source is being used, select the following registry key: HKEY_CURRENT_USER\Software\ODBC\OBDC.INI\<yourdsnname>
If SYSTEM ODBC Data Source is being used, select the following registry key: HKEY_LOCAL_MACHINE\Software\ODBC\OBDC.INI\<yourdsnname>.
Right click, and select 'Edit', 'New', 'String Value'. Set the name of the new string to 'WorkArounds2' and set its value to 128.
2 - WorkArounds2 options can be set in the data source to take advantage of non-standard or extended behavior. You may also take advantage of the options within a connection string. To do so, you would specify the following:
For WorkArounds2, specify: WA2=128