Cannot find Oracle driver even after first install was succesful

Question

Hi - I connect for the first time to an Oracle Datbase via 'Quick Connect' . I choose a random library on my drive (C;Rob\Alteryx) and create a succesfull connection. But when I exit Alteryx and start again, I get the same message as before: cannot find Oracle driver etc. Is there a mandatory location I should select for the install process?

Thanks,

Rob

dataguyW · Answer

Depending on if you are doing more of a full Oracle product install or just the thin-client, the ODBC drivers generally need to be put anywhere on your hard drive.  The key is to make sure that windows knows where that path is located.

1. Search Windows for "environment variables"

2. Click on "Advanced Tab" --> Environment Variables

3. FOR ORACLE, look for SQLPATH OR TNS_ADIN (not used as often any more), and make sure they point to the folder you put the drivers. OK.

Go to ODBC administrator to test that they can be found (search ODBC and choose 32 or 64 per your install) and see if you see that Oracle driver.  If you do, your system knows where to find the drivers and your Alteryx code should also recognize it.