This content has been marked as final. Show 2 replies
Judging by your error message it appears that you are using the Microsoft Oracle ODBC Driver.
This driver does have limitations. It is definitely not a recommended to use this driver.
You will be much better off using the Oracle ODBC driver. You can install it as part of a custom Oracle Client installation.
you were correct - it was indeed an ODBC issue. Switching to OCI has fixed the issue. This link was also very helpful:
In my case, the problem with OCI happened because I was using System DSN name instead of how it's called in tnsnames.