Kbase P10464: How to deploy a generic schema holder for an identical foreign database but different name?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/04/2009 |
|
Status: Verified
GOAL:
How to deploy a generic schema holder for an identical foreign database but different name?
GOAL:
How to deploy a generic schema holder against another identical database in SQL Server?
GOAL:
How to customize a schema holder that can accept different name for an identical foreign database?
GOAL:
If I have the same names for foreign owner and ODBC data source but different name for database, how do I deploy my schema holder
FACT(s) (Environment):
MS SQL DataServer
ODBC DataServer
Windows
Progress 9.1x
OpenEdge 10.x
FIX:
Note: following can only be accomplished when the names for ODBC data source and foreign owner are the same.
This can be done by changing the field, _File._Fil-Misc2[1], to unknown (?). The field, _File._Fil-Misc2[1] holds the physical name of SQL Server database. By changing this field to an unknown value, client can deploy a generic schema holder against another identical database in SQL Server.
Steps;
1. Connect to schema holder
Connect only to the schema holder (no need to connect to foreign database, i.e., SQL Server)
2. Run the following code:
/* Connect to the schema holder as a single user mode. */
For each _File:
Assign _File._Fil.Misc2[1] = ?.
End.