In Windows, how do I set up an ODBC source to access my Oracle database on the IU Research Database Complex?

Programs that use Open Database Connectivity (ODBC) to connect to remote databases need a way to identify the type of database and the computer to which they are connecting. This is accomplished through an ODBC data source, which associates a name with database connection information. With Oracle, the database connection information is the same as the name of the Oracle Net service you configured when you set up the Oracle Client. You will need to install the Oracle client before completing the steps on this page to set up an ODBC source. For instructions on how to install the Oracle client, see At IU, how do I download and install the Oracle 12c client for Windows?

To configure and locate an ODBC data source:

  1. From the Start menu, click Settings, and then Control Panel.
  2. Select Administrative Tools, and then Data Sources (ODBC).
  3. At the top of the "ODBC Data Source Administrator" window, select the System DSN tab, and then click Add....
  4. From the list, select Oracle in OraClient10g_home1, and then click Finish.
  5. Enter your information in the window that appears, and then click OK.

    The following example creates an Oracle ODBC data source for the iugp database on iu.edu:

    Field Explanation Example
    Data source name
    User-specified name by which you will refer to this ODBC data source
    iugp_ora
    Description
    Not required; just a phrase reminding you why you created this ODBC data source
    Oracle ODBC for iugp database on the RDC
    TNS Service name
    The Oracle Net Service Name you created for the database to which you want to connect
    iugp.iu.edu
    User name
    Usually left blank; you will be prompted for this later when you make an ODBC connection to the database

  6. The ODBC data source you added will now appear in your System DSN list. Click OK to finish your ODBC configuration.

If you need assistance, email the High Performance Systems group.

Note:

The Indiana University Research Database Complex supports research-related databases and data-intensive applications that require databases. The RDC provides an environment for database-driven web applications focusing on research, and offers the following database accounts:

  • MySQL: The RDC supports MySQL Enterprise Server. Access to phpMyAdmin is created for you by default.
  • Oracle: MySQL can meet the majority of database needs. However, if your research has an immediate requirement for specific functionality in Oracle, you may request to be considered for an Oracle database account. To do so, follow the instructions in the RDC Database and Web Services Account Application.

This is document awqf in the Knowledge Base.
Last modified on 2017-08-04 14:48:28.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.