Kbase 15236: Connecting 5 multiple databases using ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Connecting 5 multiple databases using ODBC
I have a customer that would like to connect to 5 unix db's (vers 6.3)
using ODBC.
The customer can do this a couple of different ways, but they must use
a database server for each database.
1) They can create a separate data source definition for each data-
source or they can use a single datasource definition and specify
each database and it's associated server parameters, network type
and host name.
[multidb datasource]
driver=c:\w31\system\progodbc.dll
broker=localbroker
startup=-db db1 -S demosv -N TCP -H host1 -db db2 -S demosv1 -N TCP
-H host2 -db db3 -S demosv2 -N TCP -H host3 ....
The only problem with using only one datasource for all the databases
is that the catalog functions will only display the first database
tables, columns, etc. Everything else should be ok.
Progress Software Technical Support Note # 15236