I work for a development company and we have eight different site
locations. For each site we use a billing database designed on
Progress version 8.3a. The table structures, names, etc are identical
across all eight copies of the database. The only difference is the
actual data inside.
I have written some reports that I would like to run on each copy of
the database. I'm using the OpenLink Data Access Driver (Lite
Edition) version 3.2.
Here's what I'm trying to do: Using ODBC, run the report on the first
instance of the database. Then change the ODBC connection string
information to the second instance and run the report a second time.
Then move to the third, etc.
When I open an the first ODBC connection to any instance of the DB,
the tables come through as pro1.[table-name]. If I open a second
instance of the database, I get pro2.[table-name]. I need to come up
with a way to close the first connection so that the second will open
with a datbase name of pro1 as well. If I close my reporting
application then re-open it, this works, but I really want to just
cycle through the connections without having to quit my calling
Thanks for any suggestions,