ODBC - Multiple DB Connections

[sanjus]

Environment:
Server OS: Linux RHEL
Progress (OpenEdge): 10.2x
DataServers (brokers) started for 4GL & SQL seperately.
Client: Win7 x 64
ODBC Driver: Progress Supplied (Merant/DataDirect)

My Questions:
1. How can I connect multiple DBs thru a single System DSN? Is this even possible?
2. How would I extract/reference data from multiple DBs?

TIA for all the help,

-sanju

 

[medu]

1. How can I connect multiple DBs thru a single System DSN? Is this even possible?

simply put, you can't... while progress supports starting multiple brokers for the same database (different listening port) having a broker serving more than a single database isn't possible, at least to my knowledge