Setting Up Your Computer to User Access and Excel

Creating ODBC DSN for Excel and Access to connect to Oracle 11g PROD and QA

Oracle 11g Client and Oracle ODBC drivers must be previously installed.  Contact the UMW IT Help Desk to have this done.

Windows XP

  1. Open the Control Panel.
  2. Open Administrative Tools.
  3. Open Data Sources (ODBC).
  4. Continue below under Windows XP and Windows 7.

Windows 7

Do NOT use Control Panel > Administrative Tools > Data Sources (ODBC).  Instead do the following:

  1. Execute c:\windows\SysWOW64\odbcad32.exeThis can be done either by:
  1. using Windows Explorer to navigate to c:\windows\SysWOW64 and double-clicking on odbcad32.exe
  2. enter  c:\windows\SysWOW64\odbcad32.exe  in the Search box
    Enter c:\windows\SysWOW64\odbcad32.exe in the search box at the bottom, then click on odbcad32.exe.

Windows XP and Windows 7

  1. Select the User DSN tab on the ODBC Data Source Administrator window.
  2. Click Add
  3. Select the Oracle driver – should be “Oracle in OraClient11g_home1” but could vary depending on the local setup. (Do not select “Microsoft ODBC for Oracle”).
  4. Click Finish
  5. Enter the following in the “Oracle ODBC Driver Configuration Screen”:
    Data Source Name:  Banner_Oracle_ODBC
    Description:  (optional)
    TNS Service Name:  PROD
    User ID:  your netid
  6. You may click on Test Connection to ensure the setup is correct. Enter your netid and password and click OK.

    Click OK.
  7. Click OK to close the “Oracle ODBC Driver Configuration” screen.
  8. Click OK to close the “ODBC Data Source Administrator” screen