Kbase P106752: Can different SQL Server databases be accessed from one DataServer installation?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2008 |
|
Status: Verified
GOAL:
Can different SQL server databases be accessed from 1 schema holder?
GOAL:
How do I access more than one SQL Server database from a single SQL Server DataServer installation?
GOAL:
Multiple SQL server database access through one SQL Server installation
FACT(s) (Environment):
MS SQL DataServer
Progress 9.x
OpenEdge 10.x
Windows
FIX:
DataServer for Microsoft SQL Server works through ODBC driver layer to access SQL Server databases. When various SQL Server databases reside on different servers, a machine with a SQL Server client can use different ODBC DSNs to access these servers. DataServer for Microsoft SQL Server can be installed on this machine and utilize the different ODBC DSNs to access these databases.
A single schema holder can be built containing multiple logical schemas for different databases. Upon connection, specify different logical names (-ld) and data sources (-db) for different databases.
For example, connection parameters for connecting to two SQL server databases can be:
-db sh_name -RO -ld log1 -db dsn1 -U usr1 -P usr2 -ld log2 -db dsn2 -U usr2 -P usr2
Both log1 and log2 reside in sh_name database.
dsn1 refers to data source configured for the first database, dsn2 refers to data source configured for the 2nd database.