#1 2012-07-10 13:38:01

dilip
Member
Registered: 2012-06-17
Posts: 11

ODBC

Hi
When running a job I get following error.
------------------------------------------------------------
[statistics] connecting to socket on port 3941
[statistics] connected
Exception in component tAccessInput_1
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
    at tccr_test.tccr_access_0_1.tccr_access.tAccessInput_1Process(tccr_access.java:1322)
    at tccr_test.tccr_access_0_1.tccr_access.runJobInTOS(tccr_access.java:1915)
    at tccr_test.tccr_access_0_1.tccr_access.main(tccr_access.java:1783)
[statistics] disconnected
Job tccr_access ended at 12:24 10/07/2012. [exit code=1]
----------------------------------------------------------------------
I am using 64bit Talend DI on Win7 64bit with latest 64bit MS ODBC driver and can see the Access2007 tables (source) within Talend so connection seems OK.

Can anyone advise please?

Offline

#2 2012-07-11 04:00:02

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: ODBC

Hi

I'm afraid you'd better try JDBC way. It seems that ODBC always encounter the above issue under WIN7 64bit, not only in Talend but also all platforms.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-07-11 07:03:59

alevy
Member
Registered: 2009-11-20
Posts: 1477

Re: ODBC

I've had no problems using 64-bit Talend DI on Win 7 to read Access 2007 once I installed 64-bit Access 2010.

Offline

Board footer

Powered by FluxBB