AnsweredAssumed Answered

ODBC SQL to multiple database

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

Hello

 

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?

Outcomes