Problem with MS Access target

One Star

Problem with MS Access target

Hello all,
I'm not able to run a job with an Access DB target.
The Error Message:
Exception in component tAccessOutput_1
java.sql.SQLException: Invalid string or buffer length
Environment:
Win7 64bit
TIS 5.4.1 64bit
Access 2013 64bit
64 bit ODBC DSN for Access is installed.
Any ideas?
Thanks in advance!
EDIT: After setting up a VM with a complete 32bit environment, the target works well.
It seems as if there are still some serious problems with the 64bit ODBC environment. Although this is not really a Talend problem, I found a lot of similar posts in this forum facing the same problems. Maybe Talend can perform a more detailed investigation of the problem and tell us what works and what not... (?)
One Star

Re: Problem with MS Access target

What JVM your system is having?
Is it 32-bit or 64-bit?
Check out whether it is the problem due to that...
One Star

Re: Problem with MS Access target

MS Access File Repair Tool] is the only program that recovers tables, queries, forms, reports, macros, modules, relations, field properties, non-western characters, the referential integrity, primary and secondary indexes and absolutely all field types including Memo, OLE and high precision numbers. In a few seconds it helps to fix the errors and restores the corrupted access database. It is a perfect solution to get back your corrupted MDB file and all objects contained in it.
One Star

Re: Problem with MS Access target

Poor table design can stop database in its tracks or may cause problems while using MS Access. It is one of the major causes of table issues that cannot meet the three standard forms of normalization. With the help of MS Access File Repair Tool gives is a advance solution provide perfect recovery and restoring of access database with all queries, table?s structure, primary key?s, table?s data and objects. It is fast solution to repair access database.
For More Information: http://msaccess.filerepairtool.net
One Star

Re: Problem with MS Access target

I resolved effectively using this software.
Third party Access recovery utility to restore your lost and damaged data from .mdb files. For more details about this software:- http://www.filesrecoverytool.com/access-file-recovery.html
One Star

Re: Problem with MS Access target

is your problem solved? sdasjs
One Star

Re: Problem with MS Access target

Access File Recovery is a comprehensive tool which repairs and recovers databases of MS Access. Access File Recovery Software is an intelligent solution to fix all corruption issues in ACCDB and MDB database files and saves all the deleted records and objects like indexes, queries, relations and tables, on new database.
Try:- http://www.recoverydeletedfiles.com/access-file-recovery-tool.html
One Star

Re: Problem with MS Access target

If you are still unable to recover your any database table using different programs and software then you should try Microsoft Access Repair Tool. It will definitely help you out. Using this software,you can recover all your corrupted database tables or files.
One Star

Re: Problem with MS Access target

For more info please visit this site -