Database driver error during operation

Description:

During a database operation, the following error is thrown:

[INTERSOLV][ODBC SQL Server driver][SQL Server]Syntax error during implicit conversion of <data type> value <value> to a <column data type> field.

Solution:

The above error is coming from the driver itself, not the java code-- the driver is merely complaining that it cannot make the type conversion.

The JDBC-ODBC bridge can be considered a transitional solution. Unless you have a specific reason for using this driver, you may have better success using a type-4 JDBC driver

For more information please refer to the following document on Sun's site:

http://java.sun.com/j2se/1.4.1/docs/guide/jdbc/bridge.html