Oracle ODBC Driver Install

Note: These install instructions are mostly for my own reference for now.

The Oracle ODBC Driveris a software that allows MS Access and other locally installed applications to tap into an Oracle Database.

Preparation

Account to access the schema

A personal account to access the schema is required for every individual accessing the server via ODBC. To have an account set up, email the helpdesk attention to the DBAs. You may need a business reason or authorization. You also need to know which schema you need to access; if the actual schema name is not known, a description such as "the one used by Linda Hathout to access the sleep lab data" may be sufficient.

Driver install files

The install file for the Oracle Client is about 1.9GB in size. To ensure proper installation, copy the file to the c:\ drive (not to the desktop) of the local computer before installing. The client install files is located at

Regional Server\ICU\Maintenance\Software\Oracle_V9_Client

Information needed for install

Database account name and password.

Development Server Data

Service Name: adamdev.wrha

Protocol: TCP/IP

Host Name: 172.16.77.203

Port Number: 1521

Production Server Data

Service Name: adamprod.wrha

Protocol: TCP/IP

Host Name: 172.16.77.202

Port Number: 1521

Install Instructions

<fill in details>

Contact

The driver software was provided by Peter Piatkowski, DBA with eHealth, after I was unable to find it on the Oracle site without Enterprise grade login. The ODBC drivers must be installed as part of the Oracle V9 Client. The default install does not include the ODBC drivers, so a custom install must be performed.