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

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 13:48 CSTUpdated:2017-05-31 14:22 CST
Sites:Rice University
Feedback:  0   0