This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 03-18-201605:03 AM - edited on 03-11-201909:09 AM by SydneyF
Error: "system.data.oracle client requires 8.1.7 or greater"
Please bear in mind this error is not related to Alteryx but to Oracle. This error message is returned from the Oracle Database, therefore please check with your DBA about the configuration and set up of your machine and server before reaching out to firstname.lastname@example.org. However, we are always happy to help so here are a few troubleshooting tips!
Which database connection did you use?
If you tried using the ODBC connection, try using the OCI (New Oracle Connection). If you do not know what the TNS server name it can be found in the TNSnames.ORA file. Your DBA will also know this.
What permissions do you have?
Go to the Oracle Client folder.
2- Right Click on the folder.
3- On security Tab, Add “Authenticated Users” and give this account Read & Execute permission.
4- Apply this security for all folders, Subfolders and Files (IMPORTANT).
5- Don’t Forget to REBOOT your Machine; if you forgot to do this you will still face the same problem unless you restart your machine.
*Before changing any permission settings please check with your IT
How many instances of Oracle do you have installed?
Oracle may find it difficult to navigate and select the correct version if it has more than one version installed. If you only need one of them it is better just to remove them all and reinstall the one that is needed.
Do you have the correct drivers installed?
One way to check to see if you have the right drivers installed is to set up the DSN connection through Alteryx, navigate to the ODBC admin and see if any drivers populate for either the 32 or 64 bit connections.
Please bear in mind often this error is not related to Alteryx but to Oracle. This error message is returned from the Oracle Datbase side and therefore please check with your DBA about the configuration and set up of your client before reaching out to Alteryx Support