"java.sql.SQLException:[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" Error when using the Microsoft SQLServer database

The data source can be pinged successfully. The DataWindows cannot open when you run the application on the Web. The error messages "java.sql.SQLException:[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" displays on the Web.

Cause: Use the JDBC-ODBC bridge driver when setting up the data source for Microsoft SQL Server.

Solution: Use the JDBC driver:

1. Before you configure a JDBC data source, there are a few preparations that need to be done. Refer to the section called “JDBC driver preparation” in PowerServer Configuration Guide for J2EE.

2. If you change any setting of the data source, restart the application server to apply the changes.