DB Manager error

Need help with SmartFoxServer? You didn't find an answer in our documentation? Please, post your questions here!

Moderators: Lapo, Bax

Beka Master
Posts: 6
Joined: 03 Jun 2008, 09:37

DB Manager error

Postby Beka Master » 03 Jun 2008, 09:58

Hi everyone,

I've a Windows 2003 server with Sql Server 2005, in my config.xml I do this connection to database:

Code: Select all

<DatabaseManager active="true">
   <Driver>sun.jdbc.odbc.JdbcOdbcDriver</Driver>
   <ConnectionString>jdbc:odbc:my_DB</ConnectionString>
   <UserName>name</UserName>
   <Password>pass</Password>
   <TestSQL><![CDATA[SELECT COUNT(*) FROM dbo.Users]]></TestSQL>
   <MaxActive>1000</MaxActive>
   <MaxIdle>1000</MaxIdle>
   <OnExhaustedPool>fail</OnExhaustedPool>
   <BlockTime>5000</BlockTime>
</DatabaseManager>


This work fine as application (start.bat), but DOESN'T WORK as service, i got this error:

Code: Select all

INFO   | jvm 1    | 2008/06/03 12:13:26 | --- [ Zones & Rooms ] -------------------------------------
INFO   | jvm 1    | 2008/06/03 12:13:26 |
INFO   | jvm 1    | 2008/06/03 12:13:26 |    DB Manager Activated ( sun.jdbc.odbc.JdbcOdbcDriver )
INFO   | jvm 1    | 2008/06/03 12:13:26 | 12:13:26.422 - [ SEVERE ] > DbManager could not retrive a connection. java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
INFO   | jvm 1    | 2008/06/03 12:13:26 | it.gotoandplay.smartfoxserver.exceptions.DbManagerException: The Test SQL statement failed! Please check your configuration.
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.SmartFoxServer.setupZone(SmartFoxServer.java:1765)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.lib.ConfigReader.parse_Zones(ConfigReader.java:736)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigReader.java:220)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFoxServer.java:334)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:588)
INFO   | jvm 1    | 2008/06/03 12:13:26 | Problems in config file: The Test SQL statement failed! Please check your configuration.
INFO   | jvm 1    | 2008/06/03 12:13:26 | it.gotoandplay.smartfoxserver.exceptions.ConfigurationException: The Test SQL statement failed! Please check your configuration.
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.lib.ConfigReader.readZoneConfig(ConfigReader.java:245)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.SmartFoxServer.initServerSocket(SmartFoxServer.java:334)
INFO   | jvm 1    | 2008/06/03 12:13:26 |    at it.gotoandplay.smartfoxserver.SmartFoxServer.run(SmartFoxServer.java:588)
INFO   | jvm 1    | 2008/06/03 12:13:26 |
INFO   | jvm 1    | 2008/06/03 12:13:26 | Errors found in configuration files.


I've make a guess with: System DSN, User DSN, windows authentication, User authentication, but same result.

Please help.

Return to “SmartFoxServer 1.x Discussions and Help”

Who is online

Users browsing this forum: No registered users and 17 guests