Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_TopicIcon
SMS Server connect with MySql in XAMPP
sp_NewPost Add Reply sp_NewTopic Add Topic
December 1, 2011
10:13 am
Henk Helmantel
Guest
Guests

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

December 1, 2011
2:48 am
Alvin
Guest
Guests

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?

November 30, 2011
8:50 pm
Henk Helmantel
Guest
Guests

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".

November 30, 2011
8:37 pm
Alvin
Guest
Guests

I have download and installed the ODBC driver once. How to know whether the ODBC was installed successfully?

November 30, 2011
8:22 pm
Henk Helmantel
Guest
Guests

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

November 30, 2011
7:29 pm
Alvin
Guest
Guests

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

November 30, 2011
3:57 pm
Alvin
Guest
Guests

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.

November 30, 2011
3:39 pm
Henk Helmantel
Guest
Guests

Hi Alvin,

What is the exact error message (and the content of the log) you get when you press the Test button?

Regards, Henk

November 30, 2011
3:17 pm
Alvin
Guest
Guests

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.

November 29, 2011
2:41 pm
Henk Helmantel
Guest
Guests

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

November 29, 2011
1:59 pm
Alvin
Guest
Guests

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.

Forum Timezone: Europe/Amsterdam

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 Helmantel

Administrators: Henk Helmantel: 1487