Symptom

Process Commander supports Microsoft SQL Server 2005 as the host software for the PegaRULES database and can connect to external databases that use SQL Server 2005 using Rule-Connect-SQL rules.

However, Microsoft changed the driver class name for SQL Server 2005. This can be a difficult-to-debug source of confusion and error.

If you use the old driver name, the code for SQL Server 2000 will run. The following error appears when the system attempts to connect to SQL Server 2005 using SQL Server 2000 drivers.

SQLState HY000, Error code 8009: java.sql.SQL
Exception:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect.
Parameter 1 (""): Data type 0x38 is unknown.

Solution

The Microsoft SQL Server 2000 driver class name is:

"com.microsoft.jdbc.sqlserver.SQLServerDriver";

When setting the connection to the database for SQL Server 2005, use the following class name:

"com.microsoft.sqlserver.jdbc.SQLServerDriver";