| User | Post |
|
10:13 am
December 1, 2011
|
Henk Helmantel
| | |
| Admin
| posts 195 | |
|
|
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
December 1, 2011
|
Alvin
| | |
| Guest
| | |
|
|
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
November 30, 2011
|
Henk Helmantel
| | |
| Admin
| posts 195 | |
|
|
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
November 30, 2011
|
Alvin
| | |
| Guest
| | |
|
|
I have download and installed the ODBC driver once. How to know whether the ODBC was installed successfully?
|
|
|
8:22 pm
November 30, 2011
|
Henk Helmantel
| | |
| Admin
| posts 195 | |
|
|
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…..c/5.1.html
Regards, Henk
|
|
|
7:29 pm
November 30, 2011
|
Alvin
| | |
| Guest
| | |
|
|
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
November 30, 2011
|
Alvin
| | |
| Guest
| | |
|
|
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
November 30, 2011
|
Henk Helmantel
| | |
| Admin
| posts 195 | |
|
|
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
November 30, 2011
|
Alvin
| | |
| Guest
| | |
|
|
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
November 29, 2011
|
Henk Helmantel
| | |
| Admin
| posts 195 | |
|
|
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/…..-database/.
Regards, Henk
|
|
|
1:59 pm
November 29, 2011
|
Alvin
| | |
| Guest
| | |
|
|
I would like to ask is that possible for me to make use of the Mysql database in XAMPP for SMS Server as well? I do not know how to make the connection string. I using this sms server as a part for my project.
|
|
Search 
Support Forum
Reply to Post
Add a New Topic
Quote and Reply 
Topic RSS 
