FlashChat Service stopping after server.xml change to ODBC

[GaryNiederhelman]

Following the directions here: http://www.123flashchat.gr/mssql-integration.html  I updated the server.xml file to use ODBC, but now my 123FlashChatServer service keeps automatically stopping.  I'll start it, and less than 1 minute later (looking at Services) it just stops.

Anyone have any advice? 

Flash Chat 9.8

Gary

[admin]

Hello


Thanks for your post.

To use MS-SQL as your chat database by using ODBC, we need to make sure our password_field_name in MS-SQL is encrypt by md5 or not encrypt. Otherwise we have to use "auth-url" method.
Follow the below steps:
1. Create DSN for your MS SQL
start->settings->control panel->administrative tools->Data sources(ODBC)->New DSN

2. Change the settings in "Admin Panel > Server Settings > Integration", choose "ODBC" or "Common", then fill in the panel with the required info.

After that is done, if chat still not working properly, could you help to check error logs in "<123flashchat installed folder>/server/logs/error.log"?
Or we can also get some key info in "<123flashchat installed folder>/server/output.log".



Hope this helps

thanks
Admin