7159 SMS Gateway - Developers Guide, SQL SMS API

                

Search the manual:

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

HTTP SMS API Contents | SearchASP.NET and MS SQL Server

Home > Product Manual > Developers Guide > SQL SMS API

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Developers Guide
  Tutorials
  ASP SMS API
  PHP SMS API
  HTTP SMS API
  SQL SMS API
  ASP.NET and MS SQL Server
  Ozeki database table layout
  State values
  C Sharp SMS API
  AJAX SMS API
  Delphi SMS API
  Cpp SMS API
  Java SMS API
  VB.NET SMS API
  Python SMS API
  Perl SMS API
  TCL/TK SMS API
  Coldfusion SMS API
  VB 6 SMS API
  Examples and Solutions
  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...



  • FAQ




  • Next page: ASP.NET and MS SQL Server
    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


    0