linking two databases

elisabeth · #1 (**permalink**) 11-05-03, 05:49

Is there any way to query two databases in MS Query??

Our cashiers can override fee transactions, they have to type in the reason for overriding the fee. This is stored on the SQL server.

The transaction is then sent to our oracle database however the reason for the override isn't.

Is there any way to link the two tables, JOURNAL on the SQL server and TRANSACTIONS on the oracle database?

Thanks,
Beth

arin_am · #2 (**permalink**) 11-05-03, 16:29

Yes, you can, BUT with little work. Read the link below which will guide you to do the same.

http://download-west.oracle.com/docs..._genco.htm#173

Quote:

Originally posted by elisabeth
Is there any way to query two databases in MS Query??

Our cashiers can override fee transactions, they have to type in the reason for overriding the fee. This is stored on the SQL server.

The transaction is then sent to our oracle database however the reason for the override isn't.

Is there any way to link the two tables, JOURNAL on the SQL server and TRANSACTIONS on the oracle database?

Thanks,
Beth

Internet Services

Web Development

Digital Marketing

Consumer Tech