Hi,
I'd like to send SMS messages from a database to my customers. I found this tip at http://www.ozekisms.com/index.php?owpn=400 and I'd like to know if it's relevant to my project.
One of the options you can choose to add SMS functionality to your ASP project is to use an SQL SMS gateway architecture. In this architecture, the ASP enabled website uses a database server (Microsoft SQL Server, Oracle or MySQL) for data storage. To add SMS functionality in this case all you have to do is create two database tables, one for sending SMS messages and one for receiving SMS, in the database server and use these tables in an SQL SMS Gateway configuration. In this case the SQL SMS Gateway configuration of Ozeki NG SMS Gateway will work the following way:
There are two database tables. One will be used for receiving SMS messages (ozekimessagein) and another will be used to send SMS messages (ozekimessageout). If an SMS message is received by the system Ozeki NG will insert a record into ozekimessagein. Your ASP application can read the ozekimessagein database table and check for incoming messages.
If you want to send a message, you can use the ozekimessageout table. You can insert a record into ozekimessageout. Ozeki NG SMS Gateway will periodically check your outgoing database table using an SQL SELECT and if it finds a message to be sent it will send it.
Id appreciate any response.
Thank you.
Max
I'd like to send SMS messages from a database to my customers. I found this tip at http://www.ozekisms.com/index.php?owpn=400 and I'd like to know if it's relevant to my project.
One of the options you can choose to add SMS functionality to your ASP project is to use an SQL SMS gateway architecture. In this architecture, the ASP enabled website uses a database server (Microsoft SQL Server, Oracle or MySQL) for data storage. To add SMS functionality in this case all you have to do is create two database tables, one for sending SMS messages and one for receiving SMS, in the database server and use these tables in an SQL SMS Gateway configuration. In this case the SQL SMS Gateway configuration of Ozeki NG SMS Gateway will work the following way:
There are two database tables. One will be used for receiving SMS messages (ozekimessagein) and another will be used to send SMS messages (ozekimessageout). If an SMS message is received by the system Ozeki NG will insert a record into ozekimessagein. Your ASP application can read the ozekimessagein database table and check for incoming messages.
If you want to send a message, you can use the ozekimessageout table. You can insert a record into ozekimessageout. Ozeki NG SMS Gateway will periodically check your outgoing database table using an SQL SELECT and if it finds a message to be sent it will send it.
Id appreciate any response.
Thank you.
Max