Kbase P159493: MS SQL server DataServer Add Update Table Def initions Switch to Different databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/02/2010 |
|
Status: Unverified
SYMPTOM(s):
Add update table definitions switch to different databases
In the add update screen, the qualifier showed points to test database
FACT(s) (Environment):
Two DSNs defined as data source - test and production
Examine schema df, all table "qualifiers" point to production
_db.db-addr points to test
Windows
OpenEdge 10.x
CAUSE:
The user has a mess up in the schema holder on DSN, the schema holder uses _db.db-addr to store data sources, this DSN is used to point to the database used for update. Since the _db.db-addr points to test, the runtime query is built against test instead of production
FIX:
Update meta schema filed _db.db-addr so it points production DSN