Skip to end of metadata
Go to start of metadata

Error with JDBC Connection to SQL Server


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.


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 jdbc:microsoft:sqlserver://localhost:1433;
                     selectMethod=Cursor;databaseName=scheduler -user=scheduler -password=scheduler


Newer version:
db = jdbc 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".

Write a comment…