Fixing MS Access External Resource to Oracle Database error ORA-01406

If you receive the ORA-01406 error while connecting from MS Access, there are two recommended solutions:

1. Increase the ODBC Oracle driver fetch buffer cache size

2. Switch to the Microsoft Oracle driver

A file outlining both solutions can be downloaded here:FixingMSAccessExternalResourcetoOracleDatabaseerrorORA.pdf

Picture1.png

undefined

See Also:




Keywords:ORA-01406, MS Access Oracle Error, RTPTPROD   Doc ID:107305
Owner:Jayesh P.Group:University of Illinois System
Created:2020-11-19 14:41 CSTUpdated:2020-12-08 17:59 CST
Sites:University of Illinois System
Feedback:  2   2