One Star

Microsoft Access 64bit ODBC error: Invalid string or buffer length

I have been unable to get around this error, I'm running 64bit office, windows 7, Talend 5.1.2. This job ran fine when on 32bit. I saw some info to use JDBC way, but I do not understand what that means? Does someone have an example of a connection setup that gets around this problem?
java.sql.SQLException: Invalid string or buffer length
ODBC Error:

Fetch files to iterate:

tAccessinput:

conext:
4 REPLIES
One Star

Re: Microsoft Access 64bit ODBC error: Invalid string or buffer length

ODBC Error:

Fetch files to iterate:

tAccessinput:

conext:
One Star

Re: Microsoft Access 64bit ODBC error: Invalid string or buffer length

Here is the image upload of error also I have Java 1.6.37. I do have a complex work around that involves not using an iterate to fetch the access file names, has to have hard coded connections to each database, and the order of the fields in the tAccessinput has to be strings, then intergers, then doubles.
Community Manager

Re: Microsoft Access 64bit ODBC error: Invalid string or buffer length

Hi
The following KB article provides additional information on how to create DSNs that make use of Office ODBC drivers on 64 bit versions of Windows.

Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows
http://support.microsoft.com/kb/2721825/EN-US
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Microsoft Access 64bit ODBC error: Invalid string or buffer length

I tried many options and 64 bit office install but could not get it to work consistently. I changed the process to pass cvs files of the tables to talend instead.