You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

A practical guide to setting up an IUIE connection for the most common uses within SOIC

Note: the UITS KB page "At IU, how do I download and install the Oracle Database 11g Release 2 client for 64-bit Windows? contains some useful data, however this installation is not optimal for most of our users.

Note:  These instructions assume that the OS and all related software are 64 bit.  If the user is constrained, for example, to use 32 bit MS Office in order to have ActiveX functionality in UITS SharePoint 2010, another approach will be needed.

Install and configure Oracle client software on Windows

  1. Verify that existing system and software are 64 bit:

    1. Check PC Info for 64 bit OS

    2. Check Tableau (Help->About) for 64 bit version
    3. Check Excel (File->Account->About Excel) for 64 bit version
  2. Install Oracle Data Access Components (ODAC):
    1. from \\bl-soic-gemini\software\Oracle\ODAC1120320_x64
    2. or from Oracle Download
    3. into C:\ODAC
  3. Copy configuration files:
    1. sqlnet.ora, tnsnames.ora from \\bl-soic-gemini\software\Oracle
    2. to C:\ODAC\network\admin
  4. Add path and environment variable:
    1. prepend C:\ODAC;C:\ODAC\bin; to PATH
    2. create system environment variable TNS_ADMIN=C:\ODAC\network\admin
  5. Configure ODBC DSN:

 

 

  • No labels