multiple ODBC connections in one QVW file

[#1]

How do i connect to multiple databases within one qvw file? can there be more than one connect statments in qvw script?

[rwunderlich · Accepted solution]

You can use multiple connects, but there is only one connection active at a time. A CONNECT statement will do a disconnect of any existing connect, or you can explicity DISCONNECT. So something like this:

CONNECT DB1

SQL SELECT ..

CONNECT DB2

SQL SELECT

-Rob

[#3]

Thanks Rob!