Kbase P116550: Schema holder refers to wrong foreign database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
Windows
Schema holder is connecting to a different MS SQL database than the one that it was originally created against
Data returned is from the old MS SQL database and not the new MS SQL database
Edit Connection Information has been used to change the ODBC DSN used for the MS SQL database
Using copied version of an existing schema holder
Update/Add Table utility shows tables from the new MS SQL database, not the original version
Progress 9.1x
OpenEdge 10.x
OpenEdge DataServer Category: SQL Server
CAUSE:
This is expected behaviour. Edit Connection Information can only be used to a) change the logical name of the MS SQL database or b) change the name of the ODBC DSN used to connect to the MS SQL database.
Changing the name of the ODBC DSN does not change the MS SQL database that the schema holder was created against.
FIX:
Option #1
Use Delete DataServer Schema, followed by Create DataServer Schema on the new schema holder. This will recreate the schema image for the new MS SQL database.
Option #2
Update the qualifier field stored in the _File table of the schema holder to point to the new MS SQL database. Refer to solution P101811 for more information.