Error with JDBC Connection to SQL Server

Error with JDBC Connection to SQL Server

Question:

I encounter the error:

SOS-JAVA-105  Java-Exception java.sql.SQLException("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]
                     The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect.
                     
               

Answer:

If you use an older version of the JDBC Driver, ( e.g. msbase.jar, mssqlserver.jar, msutil.jar ), then the URL for the JDBC connection in the configuration file ./config/factory.ini is different from the newer version sqljdbc.jar.

Older version:

db = jdbc -class=com.microsoft.jdbc.sqlserver.SQLServerDriver jdbc:microsoft:sqlserver://localhost:1433; selectMethod=Cursor;databaseName=scheduler -user=scheduler -password=scheduler

Newer version:

db = jdbc -class=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:1433; sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler

Please regard the different classnames and use of lowercase letters in the value "cursor".