I have an ODBC SQL that have to access to different databases on the same server
While creating the ODBC I can choose a default database.
So, as far as I can understand, I cannot connect to more dbs with 1 odbc connection
I see 2 ways to set this connection, both works fine
- set a separate ODBC connection to the 2nd db in the server
- data reader level I can use the OLE DB Wizard from data read panel
Which is the best?