Oracle In Db Connection - Error "SQL_HANDLE_ENV failed"

[CatalinaQ]

Hi!

Hoping to get some ideas to help me resolve the issue with the set up of the In-Db connection for Oracle. I'm successful querying the data with a normal input tool leveraging and OCI connection. However, as I transitioned the query to In-Db connection using a file I get the following error even though the query was read successfully.

Connect In-DB (134) Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

any thoughts are appreciated!

[RishiK]

@CatalinaQ re-installing the drivers might help resolve this.

[CatalinaQ]

Thank you! @RishiK just to clarify, you mean reinstalling the oracle client? or do you think just the ODBC drivers and changing the connection to that?

[sd4w95sf8e]

Was anything ever found out with this?  We're running into the same issue on multiple machines and we've tried reinstalling the Oracle client, ODBC drivers, and even Alteryx and are still having issues.  What's really weird is that the connection works when the workflow runs but if we go into the query builder then we get that error.

[aehrenwo]

I am getting the same error of a recent Oracle connection. the query runs fine but after the first run I cannot edit the Table/Query section. 

I get the SQL_HANDLE_ENV failed error. 

This goes away temporarily if I close and reopen Alteryx. 

Any suggestions!!??