Kbase P155589: How to connect a Progress Client with an MS-SQL Server DataServer sharing an schema holder file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/10/2009 |
|
Status: Unverified
GOAL:
How to connect a Progress Client with an MS-SQL Server DataServer sharing an schema holder file
GOAL:
Is it possible to share a schema holder file for an MS-SQL Server DataServer between multiple clients ?
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
It is possible to share schema holder files as long as it is read in single user modes and read-only mode by using the parameters -1 and -RO at the client.
Assuming that you have a functional schema holder and a remote broker started like this:
_probrkr -S <service name> -H <Windows host name>
Then it is possible to share a schema holder using a mapped drive from a file server by doing:
1) Share the Windows folder where the schema holder resides
2) From the machine where the Client Networking license is installed map the shared folder
3) Change the schema holder connection parameters to use the mapped drive and add -1 and -RO parameters
Example:
If schema holder named holder1 resides in the server at the directory c:\MSSHolders\, it can be mapped as H:\ in the remote clients
Remote DataServer broker is started with: _probrkr -S probrkr
Remote clients then can connect to the holder like this:
prowin32 H:\holder1 -RO -db testDSN -ld testSQL -dt MSS -H localhost -S probrkr