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
3 REPLIES
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