Multiple DB Connections In A Single .asp Page

Results 1 to 4 of 4

Thread: Multiple DB Connections In A Single .asp Page

  1. #1
    Join Date
    Dec 1969
    Posts
    64

    Default Multiple DB Connections In A Single .asp Page

    i wanted to know if it is possible to connect to multiple databases in the same .asp page? i have data that comes from two separate access databases and the data has to be displayed on the same page (the tables are not in the same .mdb file). i know you can execute multiple queries using the same connection object. can i use multiple connection objects in the same .asp page to get my data from these 2 separate data stores? thanks a million!

  2. #2
    Join Date
    Dec 1969
    Posts
    257

    Default RE: Multiple DB Connections In A Single .asp Page

    Yes. That will work fine.

  3. #3
    Join Date
    Dec 1969
    Posts
    64

    Default RE: Multiple DB Connections In A Single .asp Page

    thanks man. i wanted to make sure before i start coding it. thanks!

  4. #4
    Join Date
    Dec 1969
    Posts
    96,118

    Default Another alternative...

    *IF* the data in the two databases is related in any way, then with most DBs you *can* use a single query to look at both DBs. If the data is completely independent (e.g., if you are using one DB to get advertisements and the other to serve up user info), then ignore this.<BR><BR>


Posting Permissions

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