smartfoxserver.com

SmartFoxServer: 2X 2.0.0 RC1b
SmartFoxSerer API: SFS2X_API_AS3 2.0.0.RC1b
OpenSpace: SFS2X 2.0.3

I have pasted exactly what has been successful for so long in SFS 1.x and am getting the following error while having the Test SQL present.

Is there a difference in what the configuration should be in 2X?

Exception: com.microsoft.sqlserver.jdbc.SQLServerException
Message: The method executeQuery() cannot take arguments on a PreparedStatement or CallableStatement.
Description: The DBManager Test SQL failed
Please double check your SQL code and make sure that Database server is running.

Which way are you doing it code-wise?
e.g. IDBManager :: from API, which suggests that you need to pass it a string and not a prepared statement...

This is being done through configuration

What is your test SQL string?

The DB configuration, having tried it without the function as well:

<databaseManager active="true">
<driverName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverName>
<connectionString>jdbc:sqlserver://localhost:1433;DatabaseName=WizardBrewStudios;</connectionString>
<userName>userName</userName>
<password>password</password>
<testSql>SELECT COUNT(*) FROM ServerSelectTest</testSql>
<maxActiveConnections>10</maxActiveConnections>
<maxIdleConnections>10</maxIdleConnections>
<exhaustedPoolAction>FAIL</exhaustedPoolAction>
<blockTime>20</blockTime>
</databaseManager>

Has anyone solved this? I get the same error.