If you can provide me with a short description of your project, the details of your educational institution and an email address from this institution then I am sure we can work something out. You can send the information to dms@diafaan.com.
I would like to ask, the free of charge testing for me left 13 days if i uninstall and install again will it able to reset the time? I using your software as part of my FINAL YEAR PROJECT work.
I am not sure what you mean with this question. If you set up the Web Connector to forward the received messages to a web server then the PHP script can take care of handling the received messages.
The PHP script can parse the message and put it in a database or return an SMS response back to the Web Connector.
The actual HTTP parameters that are sent from the Web Connector to the PHP script depend on the query string template. With a default query string template and the default GET method the parameters are from and message. In PHP these parameters can be fetched with:
The Web Connector can be used to forward received SMS messages to the web server running the PHP script. The HTTP options can be set on the Receive SMS page in the Web Connector properties.
Sending a Get or Post command makes no difference, you can choose either one. In the query string template you can specify which parameters are sent to your PHP script.
The SQL Connector writes the whole received message in the database, it has no capabilities to parse the received message and write parts of the message in separate database fields.
If you need to interpret the received message before writing it to a database then you could use the Web Connector to send the messages to a PHP script and use this script to break up the message and write it to the database. You could also use a Scripting Connector and write a C# or Visual Basic.NET script but I think for your setup the PHP route would be easier.
I have done the connection string. Thanks.
I have another problem is that, can i set the format of the SMS so that I can retrieve the data and get information insert to the table I want?
Let say I have a table in my database called appointment and this table wants contact number, time, and date. So, can I set the format to require the user SMS with this format and after I receive it then pass to appointment table?
Post edited 2:36 pm – December 2, 2011 by Henk Helmantel
The error message you get indicates that there is something wrong with the MySQL ODBC driver on your computer, I really could not tell you how to solve this.
If the MySQL 5.1 ODBC driver is installed properly on your system you should not see the ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error message for a connection string starting with Driver={MySQL ODBC 5.1 Driver}.
If you get the same error message then there might be something wrong with the MySQL ODBC setup on your system. I recommend asking a system- or database administrator to help you figure out what the problem is.
I have add a Data Source Name in ODBC administrator. Do I choose a database when add the new data source name? Because when i create the new data source name i choose the database in XAMPP. Is it correct? But then after i type the connection string again in SMS Server it show error again.