Database Discussion - Three Databases?

Print Page | Close Window

Three Databases?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=1771
Printed Date: 28 March 2026 at 12:37pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Three Databases?

Posted By: pmormr
Subject: Three Databases?
Date Posted: 11 April 2003 at 2:24pm

Is it possible to open up three databases in the same ASP file (three different variables set to Server.CreateObject("ADO etc...) and then open up a recordset for two of them, and use the SQL statement "INSERT INTO" to put the values from the two other databases into one? I'm wondering, with the insert into statement how does it know which database to insert into, is there another field where you can put the database name and the table name or no?

Thanks,
Paul Morgan

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Replies:

Posted By: Bunce
Date Posted: 11 April 2003 at 10:52pm

Dont double post.

-------------
There have been many, many posts made throughout the world...
This was one of them.