Not quite sure what your trying to do, but couldnt you use a SQL View (or Views) to expose all the data you require? This would mean you wouldnt have to have 3 spearate connections open.

Just a thought.

>Hi All,
> I have 3 database(db1,db2 and db3) on my sql 2000 server(Datawarehouse). There is a source file which contain records referring to one or all of the databases.(the name of the database is contain in the source file.) These records needs to be updated in their respective databases. How do I code to have these records updated. I am used to working with one database on a server. Please advise.
>
>Thanks
>MA