Connection string to two different servers

[sabavno]

Hi,

I need to connect to 2 SQL Servers and then join tables in my SQL strings.

Can anybody suggest the connection string as well as how would I join the tables from the different SQL Servers?

I'd appreciate your help

Thanks.

 

[Targol]

An ODBC connection is linked to ONE server so I don't think you'll can do what you want that way. By the way, can't you join SQL server B into the DB from SQL server A (by a view for exemple) and then let SQL server A do the join for you. You'll then just have to connect SQL A in ASP (That can be easier for maintenance). Water is not bad as long as it stays out human body ;-)