SEND SMS ALERT FROM YOUR SYSTEM: Twitter Joomla HP Openview WhatsUp Gold Sharepoint Notes
    
Home Solutions Applications Industries Products About Us
    
OzekiNG-SMS-Gateway.zip (5 MB)
for Windows XP,2000,2003,2008,Vista,Windows 7,8,Windows 10
free 20 day trial version
Menu
  Welcome page
  Solutions
  Applications
  General information
  Network management
  CRM
  Workflow management
  Helpdesk
  SQL database
  Interbase
  Setup instructions
  Visual FoxPro
  MSSQL Server 2012/2014 Connection
  MSSQL Server 2016
  E-mail
  Website
  Two-factor authentication
  SMS Examples
  Products
  Contact
  Sitemap

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

E-mail: info@sms-integration.com

Useful information
How to send SMS with a GSM modem attached to your PC?


This solution is best if you are planning to send or receive up to 4000 SMS per day. Read more:
  • Prerequisites
  • Setup instructions
  • Video tutorial


    How to send SMS through the Internet?


    If you wish to send more then 4000 SMS per day, it is a good idea to use an Internet SMS service provider. Read more:
  • Prerequisites
  • Setup instructions
  • Automate phone calls!

    Ozeki Phone System XE - VoIP PBX Software is an excellent tool for making automated phone calls.

    Setup instructions for sending SMS from Interbase

    On this page you will find a detailed installation guide on how to add SMS functionality to your Interbase database with Ozeki NG SMS Gateway. Below you will find an Easysoft ODBC driver to download. Then you can start to configure your system with the help of the video tutorial and screen shots.

    Download: odbc-interbase-4_3_0-windows-x86.zip

    Video: Send SMS from Interbase (Configure your system)

    SMS communication technology has several advantages. In companies it is widely used because it is a quick and reliable service for efficient communication.

    Ozeki NG SMS Gateway makes it possible to send and receive SMS messages in your corporate IT environment. The use of this software ensures a reliable, high quality operation. In this way you will get an effective and up-to-date system. There are numbers of advantages of adding SMS functionality to Interbase with this solution. As SMS messages are the fastest way of communication you can use SMS technology to send information from your database. Any kinds of data and information can be sent in an SMS message and it is forwarded to the mobile device of the intended person. This option makes it a secure solution. Moreover, you can track down your sent and received messages as Ozeki NG SMS Gateway logs them. You will also be informed about the status of your messages in a delivery report. In this way you will get a well-organized system which provides a stable workflow in your company.

    All in all, if you add SMS extension to your Interbase database you will get a well-functioning, reliable and effective communication system. This solution offers numbers of options to improve your communication within and outside of your company. This guide gives you detailed information on the configuration of this solution.

    Prerequisites

    In order to setup this solution you need to find a way to connect your system to the mobile network. You can do this by using an Internet connection or you can setup a wireless connection by attaching a GSM phone/GSM modem to your computer. To help you make a decision, we have prepared a webpage for you: Internet based SMS connections vs. GSM modem based (wireless) SMS connections. Depending on what you select, you need the following prerequisites.

    Prerequisites for Internet based connection to the Mobile network

    If you wish to connect your system to an SMS service provider over the Internet you need the following components:

    Figure 1/a - Prerequisites for Ozeki NG SMS Gateway IP SMS connection

    In this case you need to find an SMS service provider who can reach the mobile phones in your area. This SMS service provider should be able to provide SMS service through the Internet. To find such a provider, you can check our website where we list some of them: SMPP SMS Service providers. Once you have found such a provider, you need to sign up for their service to get the connection parameters. You can use these parameters to configure your Ozeki NG SMS Gateway software.

    Prerequisites for wireless (GSM modem) connection to the Mobile network

    If you wish to connect your system to the mobile network wirelessly, you need a GSM modem or GSM phone, that you can attach to your computer with a data cable. In this case your Ozeki NG SMS Gateway software will operate this phone and will send and receive SMS messages wirelessly. To setup this connection method, you need the following components:

    Figure 1/b - Prerequisites for Ozeki NG SMS Gateway GSM modem connection

    Your checklist (for GSM modem connection):

    SIM Card - You can get this from your local mobile network operator.*
    Modem - Use a Wavecom, Siemens or Multitech modem.
    Data cable - Comes with the modem
    Computer - Recommended: Intel P4 3Ghz, 2GB RAM, 500GB HDD, Windows OS
    Ozeki NG SMS Gateway - Download it from http://www.sms-integration.com
    Interbase
    Easysoft driver for Interbase

    *The SIM card will come with a plan, that will determine how much money you will spend on each SMS.
    Ozeki NG SMS Gateway can be obtained by
    opening the download page:
    Download Ozeki NG SMS Gateway!

    System architecture

    SMS sending and receiving is very simple in this solution. It works as follows: If you receive an SMS, Ozeki NG SMS Gateway inserts it to the Interbase database. On the other way, if you would like to send an SMS messages from Interbase database, Ozeki NG SMS gateway polls the message out from the database, processes it and finally sends the message to the given mobile device. This simple but quick and reliable process can be examined in Figure 2.

    Figure 2 - Ozeki NG SMS Gateway - solution for sending SMS from Interbase

    Configuration guide

    To configure Ozeki NG SMS Gateway for Interbase please follow the steps below:

    To send and receive SMS messages from Interbase, first, you need to install an odbc-interbase-4_3_0-windows-x86.zip file

    During the installation process you need to register with an e-mail address. After the registration you need to install the ODBC driver and launch the "License Manager" (Figure 3).

    Figure 3 - Launch the License Manager

    In the "License Manager" provide the e-mail address you used at the registration at Easysoft.com (Figure 4). After you type the e-mail address click on "Request License" button on the right hand side.

    Figure 4 - Type e-mail address

    Now select the license type: if you want to use the trial version select the "time-limited trial" option and click on the "next" button (Figure 5).

    Figure 5 - Select license type

    Then select the product you wish to try and click "next" (Figure 6).

    Figure 6 - Select the product

    In the next window select one of the request mode. In our example it is "On-line request" (Figure 7).

    Figure 7 - Request a license

    Finally you get the license, a window appears with a text:" One license added", then you can see the added license in the "License Manager" (Figure 8). Click on "Finish".

    Figure 8 - Added license

    Now you need to create the table layouts you can use in Ozeki NG SMS Gateway. To configure it, start the "Interbase Console" (IBConsole) at Start menu/All programs/Codegear Interbase/IBConsole (Figure 9).

    Figure 9 - Interbase Console

    You need to extend the local server then right click on Databases icon and select "Create Database" (Figure 10).

    Figure 10 - Create database

    A window appears, browse the place where you want to save your database file (Figure 11).

    Figure 11 - Browse database location

    Then select the place where you want to save your database file. In our example it will be saved in "C:\interbase_db\" folder under the name of "OZEKI.IB". So the full path is: "C:\interbase_db\OZEKI.IB" (Figure 12). If you finish click on "Save" and "OK".

    Figure 12 - Database file name

    In the "Create database" window you can see the database to be created, and if you click on "OK" the Interbase will automatically connect to your database (Figure 13).

    Figure 13 - Create database file name

    In the appeared "Database connect" window you can specify with which user name you want to connect to the database. By default, "SYSDBA" is the administrator in Interbase. Its default password is "masterkey" (Figure 14).

    Figure 14 - Connect to database

    After you fill the boxes, click on "Connect" (Figure 15) and Interbase will connect to the database.

    Figure 15 - Username for connection

    When the connection is successful, click on the SQL icon at the top of the page (Figure 16).

    Figure 16 - Interactive SQL

    The "Interactive SQL" window is launched and you can write your table definitions (Figure 17) here using SQL language. You can execute your query with F5. Since there is no auto increment property at Interbase, write a generator and a trigger for each table. First, type the definition for table "ozekimessagein":

    CREATE TABLE "ozekimessagein" (
     
     "ID" INTEGER NOT NULL,
      "SENDER" VARCHAR(30) CHARACTER SET UTF8,
      "RECEIVER" VARCHAR(30) CHARACTER SET UTF8,
      "MSG" VARCHAR(160) CHARACTER SET UTF8,
      "SENTTIME" VARCHAR(100) CHARACTER SET UTF8,
      "RECEIVEDTIME" VARCHAR(100) CHARACTER SET UTF8,
      "OPERATOR" VARCHAR(100) CHARACTER SET UTF8,
      "MSGTYPE" VARCHAR(160) CHARACTER SET UTF8,
      "REFERENCE" VARCHAR(100) CHARACTER SET UTF8,
      PRIMARY KEY ("ID")
     );

    Then create a generator for table "ozekimessagein":

    CREATE GENERATOR G1_ID;

    Now type the table definition for table "ozekimessageout":

    CREATE TABLE "OZEKIMESSAGEOUT" (
     
      "ID" INTEGER NOT NULL,
      "SENDER" VARCHAR(30) CHARACTER SET UTF8,
      "RECEIVER" VARCHAR(30) CHARACTER SET UTF8,
      "MSG" VARCHAR(160) CHARACTER SET UTF8,
      "SENTTIME" VARCHAR(100) CHARACTER SET UTF8,
      "RECEIVEDTIME" VARCHAR(100) CHARACTER SET UTF8,
      "REFERENCE" VARCHAR(100) CHARACTER SET UTF8,
      "STATUS" VARCHAR(100) CHARACTER SET UTF8,
      "MSGTYPE" VARCHAR(160) CHARACTER SET UTF8,
      "OPERATOR" VARCHAR(100) CHARACTER SET UTF8,
      "ERRORMSG" VARCHAR(250) CHARACTER SET UTF8,
      PRIMARY KEY ("ID")
     );

    Create a generator for table "ozekimessageout", as well:

    CREATE GENERATOR G2_ID;



    Figure 17 - Interactive SQL with table definitions

    Now the tables and the generators are defined, close the "Interactive SQL" window. If you click on "Tables" or "Generators" you will see the created tables and generators. Then click on Triggers to write the triggers for the tables. Right click on the right side of the pane and select "Create..." (Figure 18).

    Figure 18 - Create triggers

    First provide a name for the trigger (Figure 19): "INID". Select table "ozekimessagein", then write the body of the trigger between the "begin and "end":

    new.id = gen_id(G1_id, 1);


    If you finish click on "OK".

    Now create a new trigger for table "ozekimessageout". Again right click on the pane and select "Create...".Provide a name for the trigger: "OUTID" and select the table "ozekimessageout". Select the generator, too: "G2_ID". Then write the body of the trigger between the "begin" and "end":

    new.id = gen_id(G2_id, 1);

    Figure 19 - Filled trigger editor

    If it is done click on "OK" and the created triggers can be seen (Figure 20).

    Figure 20 - Created triggers

    Now the definitions are done and you can close the Interbase Console.

    Now launch Ozeki NG SMS Gateway to configure it to be able to send SMS messages from Interbase. Login with your username and password. On the right hand side click on "Add new user or application" (Figure 21).

    Figure 21 - Add new user

    Select "Database user" and click on "Install" (Figure 22).

    Figure 22 - Install database user

    Now provide a name for the user. In our example it is: "interbase_db". Click on "OK" (Figure 23).

    Figure 23 - Database user name

    Select the connection string type: ODBC. Then type your connection string for Interbase 2009:

    "DRIVER={Easysoft Interbase ODBC};Server=localhost;Database=localhost: C:\interbase_db\ozeki.ib;Uid=SYSDBA;Pwd=masterkey;"

    If you use an older version of Interbase (older than Interbase 2009) then type the following connection string:

    "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost: C:\interbase_db\ozeki.ib;Uid=SYSDBA;Pwd=masterkey;"

    Please note that you need to enter the connection strings in one line without line brakes!

    The part after "Database=localhost:" refers the access path to the created database file; after the "Uid=" part you need to provide the username you used in Interbase; and after the "Pwd=" part specify the password (Figure 24).

    Figure 24 - Connection string

    If it is done click on "OK".

    Now it is time to test the system. To test the system it is needed to route all the incoming messages to the database user (Figure 25).

    Figure 25 - Inbound route

    Then it is needed to generate an incoming message via SMPP connection (Figure 26).

    Figure 26 - Incoming message

    You can see the database user has been processed the incoming message (Figure 27).

    Figure 27 - Processed message

    If you click on "SQL prompt" and query the content of table "ozekimessagein" ("select * from ozekimessagein" and click on execute) you will see that the incoming message has been successfully arrived at the table (Figure 28).

    Figure 28 - Inserted message

    To create an outgoing message, a row is needed to be inserted into table "ozekimessageout". To do this, select "insert into table ozekimessageout (receiver, msg, status) values ('+36201111111', 'Hello World', 'send');" and click on "Execute" (Figure 29).

    Figure 29 - Insert a new row into ozekimessageout

    Click on "Events" and wait until Ozeki NG SMS Gateway polls out the affected row. Then you can see that the message has been processed and it sends the message (Figure 30).

    Figure 30 - Delivered message

    Now you can see the sent message among the outgoing messages of the database user (Figure 31).

    Figure 31 - Sent message

    Thank you for reading this guide.

    Please visit the

    Request more information

    If you are interested in this solution, let us know, so we can send you more relevant information and quotation with prices. Please fill in the following form:


    Your name:
    Company:
    E-mail:
    Tel:
    Country:
    Message:
     

    Home > Applications > SQL database > Interbase > Setup instructions
    Feel free to contact us for additional information. Tel: +36 1 371 0150, E-mail: info @ ozekisms.com
    Copyright © 2000 - 2017 Ozeki Informatics Ltd. - All rights reserved.