Kbase P5231: How to make multiple database connections using a single SQL89 ODBC DSN.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/2/2005 |
|
Status: Verified
GOAL:
How to make multiple database connections using a single SQL89 ODBC DSN.
GOAL:
How to connect to multiple databases with SQL-89
FIX:
By using the "Database List" fill-in within the "Advanced" tab of the SQL89 ODBC driver setup screen, it is possible to make multiple database connections from a single SQL89 ODBC DSN. This Database List allows a user to specify a comma delimited list for four additional databases which the SQL89 ODBC driver can then connect to (in addition to the database already specified).
When choosing the "Direct" ODBC connection method (via the Database Access Mode) the same UserID, password and path must be applicable to all databases listed in the Database List fill-in. However, if the "Via Server" Database Access Mode is chosen, the "Additional Options" fill-in (shown under the Advanced tab's "Database Connection Options") must contain the additional database connection information.
EXAMPLE:
-db sports -S sportssvc -db sports1 -S sportssvc1 -db sports2 -S sportssvc2