Kbase P24272: How to have multiple clients accessing the same schema holder using only Personal Dataserver license
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/8/2004 |
|
Status: Verified
GOAL:
How to have multiple clients accessing the same schema holder using only Personal Dataserver license?
FACT(s) (Environment):
Progress 9.1x
FIX:
Once you have the schema holder, place it on a shared drive on the server,
and connect to it with read-only (-RO) option.
Progress clients will be able then to access MS SQL using local ODBC Datasource.
Example:
prowin32 -db X:\schema-holder -RO -db local-ODBC-DS -ld ds-schema-name -U user -P passwd
where X: is a mapped drive containing schema holder.
The schema holder once created can be copied to each client machine. In this way each client will connect to local schema holder.
Example:
prowin32 -db c:\wrk\schema-holder -RO ...