Topics Map > Do-IT Yourself > Applications and Software > Banner

ODBC Connection for Microsoft Access

This document is for Banner users who need Microsoft Access ODBC connection to Banner database on 64-bit Windows 7.

Workstation Configuration

Step 1:  Open a Help Desk ticket for Administrative Systems (AESS): Provide IP address of workstation requesting direct access to Banner databases. (This applies to new workstations or new IP addresses).
Step 2:  User needs to have Administrator or update privileges on C: drive.
Step 3:  Install 64-bit Oracle client (11gR2 is preferred, effective Aug., 2013).
Step 4: Store tnsnames.ora and sqlnet.ora files in %ORACLE_HOME%\network\admin folder

Note: The default Oracle home, %ORACLE_HOME% for 11gR2 is C:\Oracle\prduct\11.2.0\client_1.  If your Oracle home is different, pick the one you use.
Contact Administrative systems at admsys@rice.edu for latest sqlnet.ora and tnsnames.ora files.

Create and Configure New Data Source (ODBC)

Step 1: Open Control Panel.
Step 2: Select Administrative Tools.
Step 3: Click on Data Sources (ODBC).
Step 4: (Select one) Click System DSN or User DSN.
Step 5: Add a new driver: select Oracle in OraClient11g_home1

ODBC New Data Source

Step 6: Click Finish

Data Source

Step 1: Enter Data Source Name, Description, and Server (i.e. Prod, Banner Prod database).
Step 2: Test using the new Data Source.








Keywords:Banner Prod production database windows 7 oracle administrative tools Data sources DSN   Doc ID:73691
Owner:Diane Y.Group:Rice University
Created:2017-05-31 14:48 CDTUpdated:2021-01-06 16:28 CDT
Sites:Rice University
Feedback:  1   0