Search the manual:

Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

Hidden Contents | SearchDatabase Link Management

Home > Product Manual > Examples and Solutions > SQL SMS Gateway

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Developers Guide
  Examples and Solutions
  Telephone networks
  Pin game
  E-mail to SMS Alerts
  2 way SMS to Email gateway
  SMS Order System
  Least Cost Routing
  Load Balancing
  Asterisk PBX SMS
  SQL SMS Gateway
  Database Link Management
  MySQL Script
  PostgreSQL script
  Access
  Oracle script
  Recipient list
  SMS Service Provider
  Service Provider
  SMS PIN code query
  SMS Counter game
  SMS newsgroup
  Distributed SMS
  SMS Menu
  Google maps
  Forwarding
  Birthday greeting - SQL Express
  Birthday greeting - MySQL
  Birthday greeting - Oracle
  Instant brochure - MMS autoreply
  Alphabet letter game
  SMS sport betting service
  E-mail about outgoing SMS messages
  SMS Information Menu
  Email to SMS feature
  Reminder example
  Bulk SMS Client
  Bulk SMS to a given phone number range
  Filtering phone numbers
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 



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.


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

Webphone solutions:
- Adobe Flash video phone
- Silverlight video phone
- Web to web calls
- Web to VoIP calls

Custom SIP clients:
- Silverlight SIP VoIP client
- Flash SIP VoIP client
- C# .net SIP VoIP client
- ASP .net SIP VoIP client
- Web based SIP VoIP client

Custom VoIP solutions:
- VoIP SIP softphones
- VoIP call center clients
- VoIP IVR systems
- VoIP predictive dialer systems
- VoIP auto dialer systems
- VoIP call assistant
- VoIP call recording systems
- VoIP intercom solutions

SQL SMS Gateway


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 messages.

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 standard 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).

   Installation & configuration
   Database table layout
   State transition information
   Database link management
   ADO connection strings
   Troubleshooting
 
   MySQL
   Oracle
   MS SQL
   Postgre SQL
 
   ASP.NET(C#) & SQL Server 2005
   PHP5 & MySQL Server
   C# (Form) & MS SQL Server 2005
   Access
 


Dig deeper!
People who read this also read...





Next page: Database Link Management
Copyright © 2000 - 2013 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com