Kbase P119548: Errors querying data after updating schema holder using Generate Delta.SQL utility for DataServer fo
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
MS SQL DataServer
Windows
SYMPTOM(s):
Using the "Generate delta.sql Progress to MSS" utility to update Progress Schema Holder database and foreign MS SQL database
Resulting .DF file is successfully loaded into Schema Holder database
Resulting .SQL file is successfully loaded into foreign MS SQL database
ODBC errors occur when querying data via 4GL
S00002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '<ODBC DSN>.DBO.<TABLE>'.
S00002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'sqlsports101A1.DBO.EMPLOYEE'.
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
CAUSE:
Bug# 20061005-002
CAUSE:
The .DF file generated by the "Generate delta.sql Progress to MSS" utility contains the wrong QUALIFIER name. The QUALIFIER field lists the name of the ODBC DSN rather than the SQL Server database name.
FIX:
Option #1
Upgrade to OpenEdge 10.1B
Option #2
Open .DF file created by "Generate delta.sql Progress DB to MSS" utility in Notepad and manually adjust the QUALIFIER setting to reflect the name of the MS SQL database instead of the ODBC DSN