AnsweredAssumed Answered

ODBC SQL to multiple database

Question asked by danieledilorenzo on Aug 6, 2019
Latest reply on Aug 15, 2019 by breuber



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?