- Product Manual
- Introduction
- Installation Guide
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- 1.1 SMS basics
- 1.2 Why is SMS so successful?
- 1.3 Example applications of SMS messaging
- 1.4 SMS number formats
- 1.5 Mobile message types
- 1.6 SMSC
- 1.7 SMS Gateway
- 1.8 Two way SMS systems
- 2.1 Prerequisites
- 2.2 Network requirements
- 2.3 General Information
- 2.4 Message routing
- 2.5 Message types
- 2.6 Delivery reports
- 3.1 GSM modem
- 3.2 SMPP
- 3.3 CIMD2
- 3.4 UCP/EMI
- 3.5 HTTP
- 3.6 SMTP
- 4.1 API
- 4.2 SQL to SMS
- 4.3 HTTP to SMS
- 4.4 E-mail to SMS
- 4.5 Autoreply database
- 5.1 Performance
- 5.2 Logging
- 5.3 Errors
- 5.4 Reporting
- 6.1 Trial version
- 6.2 Licensing
- Feature list
- Commercial Information
- Search
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android
C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code
PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website
SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
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:
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;
More information
- SMS basics
- Why is SMS so successful?
- Example applications of SMS messaging
- SMS number formats
- SMS and MMS message types
- Short Message Service Center (SMSC)
- SMS Gateway
- Two way SMS system - Ozeki NG
- Hardware and software requirements
- 2.2 Network requirements
- Ozeki SMS Gateway - General information about the software
- Routing
- Message types
- Delivery reports
- GSM modem
- SMPP
- CIMD2
- UCP/EMI
- HTTP
- SMTP
- API
- HTTP to SMS gateway
- E-mail to SMS and SMS to E-mail forwarding
- Autoreply database
- Performance and scalability
- Logging
- Problem resolution
- Cost control and usage statistics
- Trial version of the SMS Gateway
- Commercial questions
Most popular
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