SQL database driven SMS gateway
The SQL database connectivity of Diafaan SMS Server saves precious development time and makes it easy to add two-way SMS or pager text messaging to your application fast.
Setting up the SQL database connector is straightforward, just use the following easy steps.
Step 1, Create the database
Step 1a, Create the database automatically
If you use Microsoft SQL Server (Express), Diafaan SMS Server can automatically create the database tables for you. That's all, your done.
Step 1b, Create the database manually
If you use another database platform, like MySQL, Oracle, Microsoft Access or PostgreSQL, the first step is to create the database tables manually or to use an existing database. Then instruct Diafaan SMS Server to connect to it with a ODBC or OLE DB connection string. See instruction for some popular database platforms: MySQL, Oracle or Microsoft Access.
Step 2, Enter the database fields
|After step 1b, specify the database tables and fields Diafaan SMS Server should use.|
Send and receive text messages!
- Just drop a new database record in the MessageOut database table to send a text message.
- Received SMS messages are automatically stored in the MessageIn database table you set up.