hello everybody
i have a little question, is it possible to use smartfox server with SQL Server??
in the past i've used smartfox with mysql and now i want to try an integration with sql server.
We're creating a unity game and we would like to use all sdk in microsoft system.
Thanks to all for the reply
SmartFox server with sql server
Re: SmartFox server with sql server
Hi,
by SQL server you mean Microsoft SQL Server?
SmartFoxServer uses standard JDBC drivers to interface with SQL databases so almost all vendors are supported.
You can find the drivers here:
https://docs.microsoft.com/en-us/sql/co ... erver-2017
Then you can read the brief instructions to set it up in SFS2X here:
https://smartfoxserver.com/blog/how-to- ... -database/
by SQL server you mean Microsoft SQL Server?
SmartFoxServer uses standard JDBC drivers to interface with SQL databases so almost all vendors are supported.
You can find the drivers here:
https://docs.microsoft.com/en-us/sql/co ... erver-2017
Then you can read the brief instructions to set it up in SFS2X here:
https://smartfoxserver.com/blog/how-to- ... -database/
Re: SmartFox server with sql server
yes Lapo i need to try to connect Smartfox with Microsoft SQL Server
Re: SmartFox server with sql server
hello Lapo
i'm setting up smartfox to use microsoft sql server
see the smartfox attachment
but i have this error in console:
how can i solve? my server is running
i'm setting up smartfox to use microsoft sql server
see the smartfox attachment
but i have this error in console:
Code: Select all
25 giu 2018 | 11:41:39,431 | ERROR | main | v2.db.SFSDBManager | | com.microsoft.sqlserver.jdbc.SQLServerException:
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Exception: com.microsoft.sqlserver.jdbc.SQLServerException
Message: Connection reset ClientConnectionId:b25d7008-7322-4099-8392-5223eacccf02
Description: The DBManager Test SQL failed: select COUNT(*) from dbo.athletes
Please double check your SQL code and make sure that Database server is running.
how can i solve? my server is running
- Attachments
-
- smartfox.png
- (100.1 KiB) Not downloaded yet
Re: SmartFox server with sql server
Hi,
this is likely an issue with MSSQL, probably how it is configured.
I am not an expert of this database, but searching a bit returned this page:
https://stackoverflow.com/questions/113 ... -from-java
Read the first reply in that page and see if your current config satisfies the first two points (enabling TCP and configuring firewall)
Cheers
this is likely an issue with MSSQL, probably how it is configured.
I am not an expert of this database, but searching a bit returned this page:
https://stackoverflow.com/questions/113 ... -from-java
Read the first reply in that page and see if your current config satisfies the first two points (enabling TCP and configuring firewall)
Cheers
Re: SmartFox server with sql server
Lapo wrote:Hi,
this is likely an issue with MSSQL, probably how it is configured.
I am not an expert of this database, but searching a bit returned this page:
https://stackoverflow.com/questions/113 ... -from-java
Read the first reply in that page and see if your current config satisfies the first two points (enabling TCP and configuring firewall)
Cheers
Lapo ok i have solved. But now smartfox when i click on sfsstandalone starts and close immediately.
Where is located the service? i thinks it's a problem on service
Re: SmartFox server with sql server
That's the sign that there's an error at startup. When SFS2X fails to complete the startup process it quits, and therefore your prompt window will close down.
Just open the log files (under SFS2X/logs/ ) and you should see the last error before the shutdown.
Cheers
Just open the log files (under SFS2X/logs/ ) and you should see the last error before the shutdown.
Cheers
Re: SmartFox server with sql server
I have solved with a reinstall of smartfox.
Something was broken.
I have resetted my game zone, with same parameters and all works.
The problem was when i have clicked sfs2x-service instead of sfs2x-standalone.
Now i can work well.
Thanks
Something was broken.
I have resetted my game zone, with same parameters and all works.
The problem was when i have clicked sfs2x-service instead of sfs2x-standalone.
Now i can work well.
Thanks
Who is online
Users browsing this forum: No registered users and 91 guests