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.
I've tried just about every solution I could find on the community to get an Oracle 32-bit connection to work. When I use the 'Other Databases>32-Bit Database Connections>ODBC', then select the database and enter my user name and password nothing happens at all, no errors, no nothing. The same thing when I try 'Other Databases>32-Bit Database Connections>Oracle OCI...'. Strangely enough if I use 'Other Databases>32-Bit Database Connections>OleDB...' the test is successful, but then nothing happens when I say OK. Also I got the connection to work yesterday, but when I try an modify the query I get the error below:
"Access to the path 'C\Users\X6138036......................log' is denied"
Using the default Oracle connection throws the 64-bit 32-bit error. Any ideas?
Since 32 bit drivers are really older versions of drivers they can be a little finicky. You may want to work with your database admin to make sure you have the proper access and use a 64 bit connection.
If you can update to the 64 bit and confirm access. Please reach out to Alteryx Support for help.
I had the same issue where I would select 32-Bit ODBC to setup a connection and nothing would happen. I found that Version 2019.4.6 has a bug that prevents connections to 32-bit ODBC sources. Version 2019.3.6 works just fine. This is an Alteryx issue.