gasrati.blogg.se

1. #MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE HOW TO#
2. #MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE INSTALL#

Open SMS Enabler's Settings dialog box and select the SMS to Database page.

Next, you should configure database connection parameters in the Settings dialog box in SMS Enabler. It is not necessary to use UTF8, though it is highly recommended to do this to avoid character encoding problems. In the above example, the default character set is set to UTF8. The 'id' column is optional and is added for convenience you can add other columns, if necessary. Here is a sample SQL statement you can use to create sms_in table:ĬREATE TABLE sms_in(id int NOT NULL auto_increment, Sent_dt datetime - the date and time when the sender sent the message Sender_number varchar - the sender's number Sms_text varchar - the text of the SMS message. The sms_in table must have the following three columns: You can add it to your existing database or create it in a new database. In your MySQL database, create a table named sms_in into which incoming SMS messages will be saved.

#MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE INSTALL#

You should install a 32-bit version of MySQL Connector, even if you are on Windows 64 bit. Install a MySQL Connector/ODBC 32-bit on the computer where SMS Enabler is installed. MySQL (using a PHP script on a website).

#MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE HOW TO#