Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    26

    Unanswered: linking two databases

    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
    Beth

  2. #2
    Join Date
    Jun 2003
    Posts
    34

    Re: linking two databases

    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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •