Assuming you are using SQL Server and you are using ADO.
If both the databases are on the same server, then u can point the initial catalogue to 'master' database. And if you have ADO command type as cmdText then, try a query like this
Insert into [db1].[dbo].[tbl_name] values(fieldnames)(values)
Insert into [db2].[dbo].[tbl_name] values(fieldnames)(values)
Although you will be running two queries..you can use the same connection. just two commands to execute :)
It should work for other type of DbConn's as well. Let me know.
--
Distributed computing ->Causality-> EventDriven ->We have the last laugh.!!
|