ODBC SQL to multiple database

Daniele Di Lorenzo
Daniele Di Lorenzo Customer
500 Up Votes Fourth Anniversary 100 Likes 100 Comments
in Platform

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?

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    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

Categories