KNOWLEDGE BASE

Error "An error occurred while communicating with the data source" Connecting to Oracle


Published: 15 Mar 2017
Last Modified Date: 08 Dec 2017

Issue

When you try to connect to Oracle, the following error occurs: 
An error occurred while communicating with the data source
 
Errors similar to the following can be found in the tabprotosrv logs:
  • Cannot load library from preferred location, "C:\Program Files\Tableau\Tableau <version>\bin\\<path>\ORAHOME\bin\oci.dll", since it doesn't exist.
  • Unable to load library "\\<path>\ORAHOME\bin\oci.dll" (error 87)

Environment

  • Tableau Desktop 10.2.0
  • Windows
  • Oracle

Resolution

Try one of the following:
  • Remove the ORACLE_HOME environment variable if its not used by another process, or edit the PATH variable to match that of another user who can connect successfully to Oracle.
  • Copy the oraociei12.dll from  C:\Program Files\Tableau\Tableau <version>\bin to C:\oracle\product\10.2.0\client_1\bin\ .

Cause

Other oracle drivers may be interfering with Tableau Desktop connecting to Oracle using the Tableau Oracle driver.
Did this article resolve the issue?