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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>