Kbase P109505: How to create different logical names for the same DB with a single SQL-89 ODBC DSN.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/3/2005 |
|
Status: Verified
GOAL:
How to create different logical names for the same DB with a single SQL-89 ODBC DSN.
GOAL:
How to connect to a single physical DB multiple times using different logical names with SQL-89
FIX:
It is possible to make multiple connections to the same physical DB using the OIB connection options.
Inside of the Data Source's ODBC Progress Driver Setup do the following:
1.- Define the Data Source Name and the rest of the entries as a regular ODBC direct connection to the DB.
2.- Press the Test Connect button.
3.- To create the additional connections with a different logical name do the following:
a) Go to the Advanced tab
b) Type the following connection parameters:
-db <PATH><DB name> -ld <logical name1> -db <PATH><DB name> -ld <logical name2> ....
Example:
-db c:\wrk\sports -ld alias1 -db c:\wrk\sports -ld alias2
4.- Press the Apply Button.
5.- Press the Test Connect button.