Problem with odbc driver:Gestionnaire de pilotes ODBC] Longueur de cha

One Star

Problem with odbc driver:Gestionnaire de pilotes ODBC] Longueur de cha

Hello, i have the error message below when i lauch a bat : Exception in component tDBOutput_1
java.sql.SQLException: Longueur de chaine ou de mémoire tampon non valide.
When i lauch it in TOS 3.1.4 i don't have the problem.
I try to change the driver but nothing change.
is some body ever see that?
thank you
One Star

Re: Problem with odbc driver:Gestionnaire de pilotes ODBC] Longueur de cha

Hi,
Did you solve the problem please? I'm facing the same problem right now and i'm blocked.
Thank you.
Moderator

Re: Problem with odbc driver:Gestionnaire de pilotes ODBC] Longueur de cha

Hi marouta01,
What's your OS version 64 bit/32 bit? And your odbc driver version? What the DB do you want to connect? Your studio build version is ?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Problem with odbc driver:Gestionnaire de pilotes ODBC] Longueur de cha

Hello xdshi,
I'm facing the same problem right now.
OS version 64 bit
ODBC driver version 15 00 4543 1000
I want to connect DB Access
I tested Talend 5.6.1 and 5.1.1, but it does not work. By cons, with Talend version 5.1.1, OS 32 bit, the same program running smoothly.
Here is the error message:
"Démarrage du job Livrable1_produit a 12:07 22/01/2015.
connecting to socket on port 4017
connected
failed to close the connection in tAccessOutput_2 :État de la transaction non valide
Exception in component tAccessOutput_2
java.sql.SQLException: Longueur de chaîne ou de mémoire tampon non valide
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(Unknown Source)
at auto.livrable1_produit_0_1.Livrable1_produit.tFileInputExcel_2Process(Livrable1_produit.java:2230)
at auto.livrable1_produit_0_1.Livrable1_produit.runJobInTOS(Livrable1_produit.java:14902)
at auto.livrable1_produit_0_1.Livrable1_produit.main(Livrable1_produit.java:14759)
32737 milliseconds
disconnected
Job Livrable1_produit terminé à 12:08 22/01/2015. ".
Thank you

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download