My Oracle Support Banner

"[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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.