Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: +36 1 371 0150
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

4.1 API Contents | Search4.3 HTTP to SMS

Home > Product Manual > FAQ > 4.2 SQL to SMS

SMS Gateway SMS Gateway Home

Solutions:

If you are insterested in how to setup automated SMS notifications, you should apply one of the following configurations:

SMS through HTTP requests
SMS from E-mail
SMS from the command line
SMS using txt files


If you are a software developer you can proceed to adding SMS functionality to your source code by clicking on one of the following links:

PHP SMS example
C# SMS example
ASP SMS example
SQL SMS example
Delphi SMS example

If you would like to send and receive SMS messages from MS Office applications, please check out the following links:

Send SMS from MS Excel
Send SMS from MS Outlook
Check out Ozeki SMS Client

 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

SQL to SMS

What is an SQL database?

 

SQL (Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.

Can I save incoming SMS messages (sender address, message text, timestamp) in a database server (MySQL/MSSQL)?

 

Yes, you can save messages with the database user, or you can configure SQL logging.

The software supports MySQL, MSSQl, Oracle, Access, Postgres, Sybase, and all other database servers that have an OleDb or ODBC driver. It is very easy to setup the SQL connection. More information is available at:
Database user page

I would like to specify different sender mobile numbers for outgoing messages. Is it possible to do it in the SQL tables to assign the sender mobile number?

 

Yes, it is possible. You should use the originator field to specify the sender number.

To configure this option, you have to check the "overrideable" checkbox in the sender address section, in the advanced tab of the SQL User configuration form.

I would like to use one database for many "database users". Is this possible?

 

Yes, it is possible, but you should use different database tables.

For the first database user, you can use ozekimessagein and ozekimessagout for receiving and sending messages. For the second database user, you need to use different table names. For example, you can use ozekimessagein2 and ozekimessageout2. These tables can have the same structure as ozekimessagein and ozekimessageout. After you have created the tables with the new names, you should modify the SQL templates on the configuration form of the second database user in Ozeki NG. In these SQL templates you should change the table names to match the new tables.

When I insert Data into Ozekimessageout table I didn't get message to my cell phone. what would be cause that I didn't get the text message that it is inserted into out table using my SQL console.

 

First you must find out if the problem is in the SQL to Ozeki or in the Ozeki to mobile network connection. To do this, first send a test SMS from the graphical user interface of the Ozeki software. If the SMS arrives to the recipient mobile phone, the problem is not in the mobile network connection.

The next step is to see if your SMS messages get from the database to the Ozeki software. To check this, insert some messages into the ozekimessageout table, then check the outbox of the database user in the graphical user interface of the Ozeki software.

Once you have identified the location of the problem, read the event list of the corresponding module and find the error message. The error message will probably give you some hints that will help you to resolve the issue.

My Ozeki NG SMS Gateway is always disconnecting from my MySQL server with the following error message: MySQL Server has gone away. What should I do?

 

You need to setup interactive_timeout value in your MySQL configuration, then modify the connection string to use interactive_timeout parameter of MySQL instead of wait_timeout parameter. If you have added interactive_timeout = 28800 to your my.ini file, restart mysql service, and use the following connection string:

Driver={MySQL ODBC 5.2 ANSI Driver};Server=127.0.0.1;Database=ozeki;User=test;Password=test;interactive=;Option=8;




Contents at a Glance:

1.1 SMS basics, Introduction to SMS messaging
1.2 Why is SMS so successful?
1.3 Example applications of SMS messaging
1.4 SMS number formats used in sending and receiving
1.5 What kind of messages can I send to a mobile device?
1.6 What is a Short Message Service Center (SMSC) or an SMS message center?
1.7 What is an SMS Gateway or an SMS application gateway?
1.8 What is a two way SMS system?
2.1 What are the prerequisites for setting up an SMS gateway?
2.2 What are the network requirements of an SMS gateway?
2.3 General Information about Ozeki NG SMS Gateway
2.4 How can I setup SMS routing for incoming and outgoing SMS messages?
2.5 What kind of message types can I use?
2.6 What kind of SMS Delivery reports are returned for submitted SMS messages?
3.1 How can I send and receive SMS messages through a GSM modem or GSM phone connected to a PC?
3.2 What is the Short Message Peer to Peer Protocol (SMPP)?
3.3 What is the Computer Interface Message Distribution Protocol (CIMD2)?
3.4 What is the Universal Computer Protocol / External Machine Interface (UCP/EMI)?
3.5 SMS messaging over the HTTP protocol
3.6 How can I send SMS messages through SMTP?
4.1 What kind of SMS APIs are there?
4.2 Is sending SMS from SQL possible?
4.3 How can I setup an HTTP to SMS configuration?
4.4 How can I setup an E-mail to SMS solution?
4.5 Can I send automatic SMS reply from a database?
5.1 How can I configure an SMS gateway for best performance?
5.2 What kind of logs are maintaned in the SMS gateway?
5.3 What kind of errors do I have to perepare for in the SMS gateway?
5.4 Can I setup reporting and cost control in the SMS gateway?
6.1 Is there a trial version available? What are the limitations?
6.2 What kind of licensing options do I have?




Next page: 4.3 HTTP to SMS