|
Subject:
|
Duel Connection
|
|
Posted By:
|
Gaz LG Danha
|
Post Date:
|
10/29/2004 6:26:29 AM
|
Am trying to select data from one database and then inserting it into another database. Tryed to use a select statement in conjuction with an insert into statement. The problem arises that when you wish to insert into a database, you specify a connection and execute that connection. To my knowledge, you can only open one connectionstring to every connection.
Anyone
It Ends Here
|
|
Reply By:
|
pgtips
|
Reply Date:
|
10/29/2004 6:49:35 AM
|
Yes, just one conn string per connection. You don't say what rdbms you're using, but most have syntax that will allow inserts into another database via SQL. For example if it's Access you can add the IN clause to specify the database; if SQL Server you can use full 4 part name to specify the other server/db with a linked server setup.
|
|
Reply By:
|
Gaz LG Danha
|
Reply Date:
|
11/2/2004 3:20:02 AM
|
Yes indeed. Thankyou kind pgtips.
It Ends Here
|
