ODBC SQL to multiple database

Daniele Di Lorenzo

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?

Björn Reuber

Hi Daniele,

 

in fact it's nearly the same. Some customers/partners prefer OleDB some ODBC. But for Board it's only another connection, neverthelless if its odbc or oleDB

 

Regards

Björn