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:
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.