topic Re: Microsoft Access 64bit ODBC error: Invalid string or buffer length in Talend Studio

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

_AnonymousUser — Thu, 18 Oct 2012 18:23:05 GMT

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:

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

_AnonymousUser — Thu, 18 Oct 2012 18:26:57 GMT

ODBC Error:

Fetch files to iterate:

tAccessinput:

conext:

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

Anonymous — Fri, 19 Oct 2012 00:49:06 GMT

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.

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

Anonymous — Fri, 19 Oct 2012 03:11:55 GMT

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

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

Anonymous — Fri, 02 Nov 2012 02:02:33 GMT

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.