Configuring an ODBC connection to InfoAccess in Windows

InfoAccess users need to configure an ODBC connection in Windows before their DBMS will connect to InfoAccess's Oracle servers. This KB article explains how to configure a 32-bit or 64-bit ODBC connection in Windows.

Setting up the ODBC connection

These directions apply for both 32-bit and 64-bit ODBC connections. The only difference between 32-bit and 64-bit configurations is noted in the first step below. Important! You must be an administrator on your computer to follow these steps. If you are not an administrator, please contact your IT support staff for assistance. If you are an administrator and you have issues with installation, please contact your IT support staff for assistance.
  1. Locate "ODBC Data Sources". The easiest way to do this is to press the Windows key and type "ODBC". Otherwise, "ODBC Data Sources" is located in Control Panel -> Administrative Tools. Note: there is a different configuration administrator for 32- and 64-bit connectors; choose whichever one is appropriate to your needs. You may have to configure both 32- and 64-bit InfoAccess connections. Configuration is done separately for each connection.

    SearchforODBC.png

  2. Click on the "System DSN" tab, and then "Add".

    SystemDSNTab.png


  3. Select the version of Oracle client you wish to add, then click "Finish". Common versions you may see are 11g or 12c.

    Createnewdatasource.png


  4. Configure the client. You must fill in the following fields:

      Data Source Name: user-friendly name of the data source.
      Description: user-friendly description of the data source.
      TNS Service Name: name of the server as it is recorded in your tnsnames.ora file.
      User ID: your InfoAccess user ID.

    Remember to remove the check from the "Enable Query Timeout" box (if present), then click "OK". You may click the "Test Connection" button, which will have you log in to InfoAccess with your credentials and test the connection. If the test completes successfully, the Oracle ODBC connection was successfully configured.

    OracleODBCDriverConfiguration.png

Need More Information or Help?

If you have questions about the steps in this document, please contact the Office of Data Management and Analytics Services (ODMAS) at datagov@data.wisc.edu.



Keywords:InfoAccess Info Access ODBC open database connectivity configure set up oracle   Doc ID:89680
Owner:Joe N.Group:Office of Data Management & Analytics Services KB
Created:2019-02-13 13:37 CSTUpdated:2019-05-03 08:37 CST
Sites:DoIT Help Desk, Office of Data Management & Analytics Services KB
CleanURL:https://kb.wisc.edu/configuring-an-odbc-connection-to-infoaccess-in-windows
Feedback:  0   0