Allan liu, January 30, 2018 - 3:46 pm UTC
it is useful to clear out my concept- but there are still questions which has not been addressed.
January 31, 2018 - 12:07 am UTC
1. I think ODBC implementation/enablement is through ODBC driver, correct?
PC program (eg excel) communicates with ODBC: "Give me data from table X"
ODBC talks to a specific driver to do the mapping:
2. If answer to my first question is yes, is ODBC driver specific to database?
ODBC talks to a specific driver to do the mapping:
3. ... how do I connect without the ODBC driver for Oracle then?
You can download the Oracle drivers by starting here ...and once installed, you'll be able to pick an Oracle driver when you add a new destination
ODBC Drivers
Shelley, January 31, 2018 - 2:44 pm UTC
Please also consider the type of drivers that are needed. There are 32 bit and 64 bit drivers. Factors that need to be considered are - What is the client PC O/S bit and the database server O/S bit.
thank you
Allan liu, February 01, 2018 - 5:05 pm UTC