Versions Compared

Old Version 1

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
Aqua Data Studio version 17 and higher use Java 1.8. Oracle has removed the JDBC-ODBC bridge driver in Java 1.8. The driver is not bundled with Aqua Data Studio which could cause a missing driver error. Aqua Data Studio can run using Java 1.8 and still use the JDBC-ODBC bridge from Java 1.7 if Java 1.7 is added to the installation. See How to Install the Java JDBC-ODBC Driver for installation instructions.

Table of Contents

Anchor
create_odbc_data_source
create_odbc_data_source
Create an ODBC Data Source from your Excel file

  1. Within Windows, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) and right-click Data Sources to Run as Administrator
  2. Click on the System DSN tab if you want any other user of that computer to be able to access the ODBC data source.
    Click on the User DSN tab if you want only your username on that computer to be able to access the ODBC data source.
  3. Click the Add button within the DSN tab.
  4. Within the list of available drivers, choose "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" and click Finish
  5. Within the ODBC Microsoft Excel Setup dialog, enter a Data Source Name, enter a description and click Select Workbook...
  6. Browse to the Excel file you wish to use and click OK

  7. Within the DSN tab, you should now see the Data Source Name you entered above in step 5. Click OK
  8. Now, within Aqua Data Studio, continue with the server registration process

Anchor
register_a_connection_for_your_odbc_data_source
register_a_connection_for_your_odbc_data_source
Register a connection for your ODBC Data Source in Aqua Data Studio

For Microsoft Excel, a single file is stored on a host machine either as a .xls file or a .xlsx file.

Add the ODBC
data source		Create Server GroupRegister a Microsoft
Excel File		Enter Properties

Generic ODBC
Properties MS Excel		Query an Excel File
Info

Your installation of Aqua Data Studio bit version ( 32bit or 64bit ) must match your ODBC Driver for Excel. Only 32bit ODBC drivers work with the 32bit version of Aqua Data Studio. Only 64bit ODBC drivers work with the 64bit version of Aqua Data Studio. Mismatching the driver type with the version of Aqua Data Studio will prevent Aqua Data Studio from successfully connecting to your ODBC datasource.

There is currently no way to distinguish User DSN ODBC driver 32bit versions from 64bit versions because of an issue with Windows ( http://support.microsoft.com/kb/942976 ).

...

Info

Queries on Microsoft Excel ODBC Data Sources do require that the Worksheet name be surrounded by brackets, like

select * from [Sheet1$]

for Aqua Data Studio to successfully execute them.

Anchor
microsoft_odbc_driver
microsoft_odbc_driver
Microsoft's ODBC Driver

You can get more information about Microsoft ODBC connections here

...