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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download