Querying Multiple dBs

Results 1 to 2 of 2

Thread: Querying Multiple dBs

  1. #1
    Join Date
    Dec 1969

    Default Querying Multiple dBs

    I've got two separate SQL 7.0 dBs, I want to create a query in ASP that joins tables from both dB's, I've used two connection strings, but I can't work out how to create 1 recordset from the two connections?

  2. #2
    Join Date
    Dec 1969

    Default RE: Querying Multiple dBs

    you can't directly. you'd have to use two recordsets and somehow unify them with script. not at all efficient, I'm afraid.

Posting Permissions

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