Support forum
10:13 am
Hi Alvin,
The error message indicates that the driver is not properly installed on the Diafaan SMS Server computer so there is probably something wrong with the installation or there might be a spelling error in the connection string you have entered in Diafaan SMS Server.
You can try adding a Data Source Name (DSN) in the ODBC administration and use this as the connection string: DSN=myDsn;
Regards, Henk
2:48 am
I have found the Data Source ODBC and confirmed that I have install the ODBC. So, do I need to configure anythg in the Data Source ODBC or direct enter teh connection string at Add Connector->Connection String ODBC?
8:50 pm
You can look it up in the Windows ODBC Data Source Administration (type ODBC in the Windows 7 start menu). It has a list of all ODBC drivers installed on your system. There should be an entry "MySQL ODBC 5.1 driver".
8:37 pm
I have download and installed the ODBC driver once. How to know whether the ODBC was installed successfully?
8:22 pm
This error indicates that the MySQL ODBC 5.1 driver is not installed on the computer where you run Diafaan SMS Server.
The MySQL ODBC 5.1 driver can be downloaded from http://dev.mysql.com/downloads/connector/odbc/5.1.html
Regards, Henk
7:29 pm
It show database test fail. And the error log is like this:-
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
3:57 pm
I have read for the guide and documentation in the website. But still, I cannot solve the problem for the ODBC connection string with my XAMPP MySql databse. The ODBC connection string that I have entered is:-
Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;charset=UTF8;Database=cutting;User=root; Password="";Option=3;
After I have entered the information and click TEST then an error message was returned.
3:39 pm
Hi Alvin,
What is the exact error message (and the content of the log) you get when you press the Test button?
Regards, Henk
3:17 pm
I have refer to the guide and documentation that provided in your website. But I am still facing the problem to set up the ODBC connection string.
Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;charset=UTF8;Database=cuttinghairsalon;User=root; Password="";Option=3;
This is the sample ODBC connection string that I have enter but when I click TEST then return the error.
2:41 pm
Hi Alvin,
Yes, you can use a MySQL database with Diafaan SMS Server. You can find some information on how to use MySQL on http://www.diafaan.com/how-to/mysql-database/.
Regards, Henk
Most Users Ever Online: 529
Currently Online:
2 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 671
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1140
Posts: 3897
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1487