ODBC Connection to 2 SQL Servers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ODBC Connection to 2 SQL Servers

I use an ODBC connection to link to a sql server via BrioQuery. Is it possible to connect to 2 sql servers at the same time and run a query with tables from both servers? I can do this using T-SQL but the ODBC administrator does not seem to allow more than one server connection at a time. Any suggestions for me? Andrew
I think it may not be possible as the connection string is limited to the server name and database name. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.