SQL Server Performance Forum – Threads Archive
ODBC Connection to 2 SQL ServersI 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.