Online Help Process Modeler
.

Connection to Oracle Repository fails

The connection to an Oracle Repository fails

In order to connect to an Oracle database, some additional drivers may be needed. If you already have a working Oracle client on your machine, you may start at step #3.

  1. From the Oracle website, download the ODAC client that supports your Oracle Database. For versions 9.2, 10.1, 10.2, 11.1, and 11.2 you may use the links below. The smaller packages with Xcopy Deployment will suffice:
  2. Install the ODAC client following the instructions provided within the download file (“readme”). Make sure to add the Oracle directories to the system PATH environment variable as indicated in the instructions.
  3. Navigate to the Oracle client directory into the “odp.net\bin\{versionNumber}” sub-directory. The path will look something like this: “%ORACLE_HOME%\product\11.2.0\client_1\ODP.NET\bin\2.x\”.
  4. Copy the file “Oracle.DataAccess.dll”
  5. Open the Process Modeler installation directory. [Where is it?]
  6. Replace the existing “Oracle.DataAccess.dll” file with the one you have just copied from the Oracle directory.
  7. After restarting Visio you should be able to connect to the Oracle repository.