I'm trying to pass SQL 2K the following update command but an getting an invalid connection handle on the SQLEXEC() statement. I'm guessing that the problem is due to the update command referencing more than one server and database. How can I get around this error?

UPDATE table1 set table1.field1=server2.database2.owner2.table2.field2 where
table1.field1=server2.database2.owner2.table2.field2

My SQLCONNECT is SQLCONNECT('DSN1').

I tried adding a second SQLCONNECT statement using the DSN to connect to the second server and database but the SQLEXEC() statement only has a place to use one connection.

LCannon...