Verify your 1010data ODBC configuration

After you have imported the 1010data-supplied configuration options, you can verify the settings.

To verify your 1010data ODBC configuration:

  1. Navigate to the folder containing the 1010data ODBC configuration programs.
    1. Click the Start button.
    2. Click All Programs.
    3. Click 1010data.
    4. Click 1010odbc.
  2. Open the configuration program corresponding to the versions of Tableau and Windows you are using.
    • If you are using the 32-bit version of Tableau on a 64-bit version of Windows, click Configure 32-bit ODBC.
    • Otherwise, click Configure Native ODBC.

    If you are not sure whether you are using the 32-bit or 64-bit version of Tableau, open Tableau and click Help > About Tableau. The About Tableau dialog shows which one you are using.

    Once you have selected the configuration program corresponding to the version of Tableau you are using, the ODBC Data Source Administrator dialog is displayed.

  3. Click the System DSN tab.
    Note: You must have administrative privileges to create or modify system DSNs. If you do not have administrative privileges, contact your system administrator.
    The list of System Data Sources is displayed.

  4. In the System Data Sources list, click the data source you wish to verify.

    Note: This example verifies the data source that was created in Configure the 1010data ODBC driver (i.e., TableauOn1010data).
  5. Click Configure.
    The SQL1010 ODBC DSN Configuration dialog is displayed.

  6. In the SQL1010 ODBC DSN Configuration dialog, verify the settings.
    Table 1. SQL1010 ODBC DSN Configuration Settings
    Tab Settings
    Connection Verify Reconnect and Mangle pathnames are selected.
    SQL Verify Use metadata in SQL translator is selected.
    Driver Verify Report errors in SQLSetStmtAttr is selected.
    Types Verify the following:
    • HHMMSS is set to SQL_TYPE_TIME
    • Timestamp is set to SQL_TYPE_TIMESTAMP
    • YYYYMMDD is set to SQL_TYPE_DATE
    Note: You should not alter any of these options. Any of the other DSN options are configurable.
  7. Click Test to validate the credentials.

    A notification dialog is presented indicating either success or failure.

  8. Click OK to dismiss the notification dialog.
  9. Click OK to dismiss the SQL1010 ODBC DSN Configuration dialog.
  10. Click OK to dismiss the ODBC Data Source Administrator dialog.