"[Microsoft][ODBC Driver Manager] Invalid string or buffer length" Signaled when Loading Data from a Microsoft Office 32-bit Excel or Access Database on a 64-bit Windows Server Using ODI 11g
(Doc ID 1571238.1)
Last updated on AUGUST 12, 2020
Applies to:
Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]Information in this document applies to any platform.
Symptoms
The following message is received when running an Oracle Data Integrator (ODI) 11g Interface that loads data from a Microsoft Office 32-bit version of Excel (or Access database) using an ODBC connection and a 32-bit JVM on a 64-bit Windows server:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3906)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1677)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |