devxlogo

Accessing 2 or More Databases

Accessing 2 or More Databases

Question:
How do I access more than one database (e.g., Oracle and Access) via a Powerbuilder application? I currently have ODBC drivers for both databases, but cannot access the required tables simultaneously.

Answer:
You will need to create two transaction objects and connect to each database with a different transaction object. Then you can specify which transaction object to use in your code.

devx-admin

Share the Post: