SFS2X database connection

Post here your questions about SFS2X. Here we discuss all server-side matters. For client API questions see the dedicated forums.

Moderators: Lapo, Bax

TiagoR
Posts: 83
Joined: 15 Mar 2010, 11:42
Location: Portugal
Contact:

SFS2X database connection

Postby TiagoR » 09 Jun 2011, 13:42

Hi,
i'm havin trouble to connect to my DB with SFS2X, in SFSPro we used the following settings:


Code: Select all

<DatabaseManager active="true">
   <Driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</Driver
   <ConnectionString>jdbc:sqlserver://DB_IP_ADDRESS;databaseName=DB_NAME;integratedSecurity=false;;</ConnectionString>
   <UserName>DB_USER_USERNAME</UserName>
   <Password>DB_USER_PASSWORD</Password>
   <TestSQL><![CDATA[SELECT Count(*) FROM [dbo].[USER]]]></TestSQL>
   <MaxActive>10</MaxActive>
   <MaxIdle>10</MaxIdle>
   <OnExhaustedPool>fail</OnExhaustedPool>
   <BlockTime>5000</BlockTime>
</DatabaseManager>


and it worked fine, now in SFS2X it doesnt connect :cry: and on server start get the following error:

Code: Select all

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.


can anybody help out?

Thanks
TR
User avatar
Bax
Site Admin
Posts: 4522
Joined: 29 Mar 2005, 09:50
Location: Italy
Contact:

Postby Bax » 10 Jun 2011, 07:43

Which version of SFS2X are you using?
Paolo Bax
The SmartFoxServer Team
TiagoR
Posts: 83
Joined: 15 Mar 2010, 11:42
Location: Portugal
Contact:

Postby TiagoR » 13 Jun 2011, 08:19

Thanks bax,
I just notisted there's a patch for the server :oops:

And its working fine now.
TR

Return to “SFS2X Questions”

Who is online

Users browsing this forum: DavinVicy, DerikFent, JerodSa and 32 guests