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.