Kbase P75517: Seeing incorrect set of data for the referenced database when connecting to multiple schema holder's
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/3/2004 |
|
Status: Unverified
FACT(s) (Environment):
DataServer
SYMPTOM(s):
Seeing incorrect set of data for the referenced database when connecting to multiple schema holder's with the same foriegn database name (-ld)
Not seeing the correct set of data for the referenced database
Seeing incorrect set of data for the database being referenced
Seeing data for another database even though absolute path is defined within 4GL
Progress client is connected to multiple schema holders at the same time
Both schema holders have the same / identical logical name defined for foriegn database
Selected working database shows both PROGRESS and foriegn database are connected
In the data dictionary, the correct image is seen for each databases
CAUSE:
This problem will occur when you connect to multiple databases that have the same logical name and/or foriegn name defined for the foreign database.
The progress client goes through a procedure to check for a list of database names. In a situation where there are identical names, the client already assumes that it's connected to that foriegn datasource when in actuality it's not.
FIX:
Make the logical name and/or the foreign database name unique from one another
Directory A
database name of the schema holder (-db)=schholder1
**logical name of the foreign database (-ld)=testschema
Directory B
database name of the schema holder (-db)=schholder
**logical name of the foreign database (-ld)=test2schema
Progress solutions that explain how this can be done are;
P19790, "How to change the -ld (logical name) of my foreign data source via 4GL?"
18896, "How To Change The Logical Db Name with DataServer Schema Holder?"