MSSQL: Error returned using the JDBC:ODBC-Driver with JAVA code generation
From The CA Plex Wiki
Contents |
Symptom
Inserting a row returns ERR when connected to a MS SQL Server 2005 database
Identification
Cause
The JDBC:ODBC-Driver is not working correctly with a MS SQL Server 2005 database.
Resolution
Use the JDBC:JTDS:SQLSERVER-driver instead. ( here you can read how to install the JDBC:JTDS:SQLSERVER-driver in Plex )
Microsoft also provide a native JDBC driver for SQL Server which is another alternative.
The JDBC:ODBC bridge is not recommended (by anyone) for production applications. Sun says:
"The JDBC-ODBC Bridge should be considered a transitional solution. Sun Microsystems and DataDirect Technologies are working to make the Bridge more reliable and robust, but they do not consider it a supported product. With the development of pure Java JDBC drivers, the JDBC-ODBC Bridge should become unnecessary."
