• After more than 30 years running websites and forums I am retiring.

    I have made many friends through the years. I will cherish my time getting to know you. I wish you all the best. This was not an easy decision to make. The cost to keep the communities running has gotten to the point where it's just too expensive. Security certificates, hosting cost, software renewals and everything else has increased threefold. While costs are up ad revenue is down. It's no longer viable to keep things running.

    All sites will be turned off on Thursday 30 November 2023. If you are interested in acquiring any of the websites I own you can Email Schwarz Network.

Opinion needed


Oct 17, 2012
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.
I’d appreciate any response.
Thank you.

Top Bottom