If you use the Ozeki NG - SMS Gateway, you can send and receive SMS messages
using a database server with the help of SQL queries.
In order to use this option, you need to have a database server (such as Oracle,
Access, MySql, MS SQL, Postgres, etc.) installed, and two database
tables should be created:
ozekimessageout and ozekimessagein.
One of these will be used for sending and the other for receiving SMS
The SQL SMS Gateway is excellently convenient for IT
professionals to enhance established IT systems by adding SMS functionality
to web-based applications (ASP, PHP) and enterprise management software.
The integration of the SQL SMS Gateway will enable you to send and receive
a large amount of SMS messages and to establish automated
SMS notification and processing systems.
Figure 1. - OZEKI NG - SMS Gateway connecting to a database server
Ozeki NG - SMS Gateway will connect to the database through a
ADO or ODBC connection (Figure 1). Using this connection, it will periodically
query the ozekimessageout database table for outgoing messages using a SELECT
statement and will INSERT incoming messages into the database table used for
incoming messages (ozekimessagein).