Support forum
Add Reply
Add Topic
10:08 am
QuoteHello Henk,
This was exactly the case ! A little typo in one field on the SQL conector DB tables.
Thank you. Hope this will help troubleshoot any further same pbl.
My very best
Tony
9:55 am
May 28, 2013
Offline
Hello Tony,
The most likely reason for this error is that there is a mismatch between the layout of your database tables and the settings in the SQL Connector of Diafaan SMS Server. When the field names in the SQL Connector do not correspond with the field names in your database, Diafaan SMS Sever will generate an invalid SQL query for your database.
I would like to see the communication log for the SQL Connector and the configuration file (menu options File-Export-Configuration). You can send these files to dms@diafaan.com.
Regards, Henk
6:08 pm
Hi
First of all, very good work on the SMS Server.
We are in the trial period to test your product. We are trying to connect to our MySql DB (see topic for the versions) thru MySQL ODBC 5.3 Unicode Driver : the SQL connector connects well but few seconds after connecting OK it returns to KO with the following message :
"ERROR [42000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.43-37.2-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM ORDER BY' at line 1"
Seems that the SMS Server is chating using old language here , no ?
Thank you for your help and keep going with your good work.
Tony
Most Users Ever Online: 529
Currently Online:
4 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 680
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1156
Posts: 3946
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1511