topic Re: MS SQL ODBC problem - Optional feature not implemented in Talend Studio

MS SQL ODBC problem - Optional feature not implemented

Anonymous — Sat, 16 Nov 2024 13:04:48 GMT

We are writing to table in a SugarCRM installation running on MS SQL 2005 Express and we get this problem when writing to the contacts table:
connecting to socket on port 3342
connected
Exception in component tDBOutput_4
java.sql.SQLException: Optional feature not implemented
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)

Re: MS SQL ODBC problem - Optional feature not implemented

Anonymous — Wed, 23 Feb 2011 10:39:15 GMT

Does anyone recognize this problem? Is it an ODBC problem? We are using a generic tDBOutput writing to an ODBC connection. I have never seen this using a tMysqlOutput for instance.

Re: MS SQL ODBC problem - Optional feature not implemented

Anonymous — Wed, 23 Feb 2011 13:01:45 GMT

Generally this error comes when there is an error in the SQL statement.

Re: MS SQL ODBC problem - Optional feature not implemented

Anonymous — Wed, 23 Feb 2011 17:41:13 GMT

Thank you. But there should not be any difference between the SQL that Talend generates for this and the SQL it generates for the other tables...

Re: MS SQL ODBC problem - Optional feature not implemented

Anonymous — Thu, 24 Feb 2011 11:54:49 GMT

While using ODBC this error pops out when there is SQL statement Problem. When using the MYSQL Jar the clear error wil be shown.