https://community.qlik.com/t5/Talend-Studio/tAccessInput-error/m-p/2202241#M4015 * Hello * <BR />I try to make a test sample table extraction from an Access database to a 97 tLogRow.Lors execution of the following error recurs. <BR />(Exception in component tAccessInput_1 <BR />java.sql.SQLException: Trop peu de param?tres. 1 attendu. <BR />at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) <BR />at dwproduction.extraction_0_1.Extraction.tAccessInput_1Process(Extraction.java:583) <BR />at dwproduction.extraction_0_1.Extraction.runJobInTOS(Extraction.java:965) <BR />at dwproduction.extraction_0_1.Extraction.main(Extraction.java:830)) <BR />I know it comes from or what the prob or solution.merci help me. <BR /> <BR />Note: Windows 7 64 bit / talend Version: 5.2.0 Build id: Jre r92826/Java 7 Fri, 14 Dec 2012 22:39:52 GMT _AnonymousUser 2012-12-14T22:39:52Z https://community.qlik.com/t5/Talend-Studio/tAccessInput-error/m-p/2202241#M4015 * Hello * <BR />I try to make a test sample table extraction from an Access database to a 97 tLogRow.Lors execution of the following error recurs. <BR />(Exception in component tAccessInput_1 <BR />java.sql.SQLException: Trop peu de param?tres. 1 attendu. <BR />at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) <BR />at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) <BR />at dwproduction.extraction_0_1.Extraction.tAccessInput_1Process(Extraction.java:583) <BR />at dwproduction.extraction_0_1.Extraction.runJobInTOS(Extraction.java:965) <BR />at dwproduction.extraction_0_1.Extraction.main(Extraction.java:830)) <BR />I know it comes from or what the prob or solution.merci help me. <BR /> <BR />Note: Windows 7 64 bit / talend Version: 5.2.0 Build id: Jre r92826/Java 7 Fri, 14 Dec 2012 22:39:52 GMT https://community.qlik.com/t5/Talend-Studio/tAccessInput-error/m-p/2202241#M4015 _AnonymousUser 2012-12-14T22:39:52Z https://community.qlik.com/t5/Talend-Studio/tAccessInput-error/m-p/2202242#M4016 Test if you can establish your ODBC connection with an other tool. <BR />Please post you properties for the tAccessInput component as screenshot. Sun, 16 Dec 2012 07:29:19 GMT https://community.qlik.com/t5/Talend-Studio/tAccessInput-error/m-p/2202242#M4016 Anonymous 2012-12-16T07:29:19Z