Could you try launching Tableau Prep as an administrator (right-click on the shortcut and select Run as an Administrator).
Have you also restarted your computer after installing the driver ?
Hi Gerhard, did you put the information on tnsnames.ora?
sure i did. It's our Data Warehouse and, as i mentioned above, i can access the DWH through Tableau without any problem. I only get the connection-error within Tableau Prep ....
i tried to run it as an administrator right before, but i comes up with the same error. And i did restart after installtion, i deinstalled and reinstalled it several times, but it always comes up with the same error.
i forgot to mention, i've tried also to get a connection to a different Oracle-DB with the same results.
I have the same issue.
- Checked that it is the correct driver (Prep, version 2018.1.2)
- Restarted after installation
- oci.dll is in place.
- Tableau desktop can connect to the same DB no problem.
Has there been any update on this?
Just a note: My issue was resolved by installing the Oracle Instant client version 2_1 and pointing my ORACLE_HOME environment variable there.
Thanks to the support team