Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

ODBC 5.3 driver /Microsoft-IIS/8.5 Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503
sp_NewPost Add Reply sp_NewTopic Add Topic
March 13, 2016
10:08 am

Hello 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


March 11, 2016
9:55 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall 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

Regards, Henk

March 10, 2016
6:08 pm

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.


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502