Forum Discussion
ODBC call failed. ORA-01406
Trying to link to tables on our server which has never been an issue. ODBC connection is fine, using Driver Oracle in OraClient 11g_home 1. Selecting Data Source ODBC Database and selecting Link to...
Thanks for the suggestions, the issue was in the ODBC Oracle settings, I increased the Fetch Buffer Settings from 64000 to 640000 and that fixed it.
That's great!
I'm guessing you have one ore more Long Text columns in the db. You may want to create a query to check the maximum length, and adjust the setting accordingly.