Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

PostgreSQL Contents | SearchDate Format Strings

Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > Pervasive SQL

 


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.

How to send SMS text messages from Pervasive SQL

This guide provides you information on how to send and receive SMS text messages using Pervasive SQL with Ozeki NG SMS Gateway. You need to download and install Ozeki NG SMS Gateway to your computer and then create a database user in the software. Please find a more detailed configuration guide below.

  1. Step: Install Pervasive SQL
  2. Step: Start Pervasive Control Center and Documentation
  3. Step: Click on Create a new SQL document option
  4. Step: Select the database in which you wish to create database tables
  5. Step: Insert Create table script

CREATE TABLE "ozekimessagein"(
 "id" IDENTITY DEFAULT '0',
 "sender" VARCHAR(50),
 "receiver" VARCHAR(50),
 "msg" VARCHAR(320),
 "senttime" VARCHAR(100),
 "receivedtime" VARCHAR(100),
 "operator" VARCHAR(100),
 "msgtype" VARCHAR(160),
 "reference" VARCHAR(100),
 PRIMARY KEY ("id")
);

CREATE TABLE "ozekimessageout"(
 "id" IDENTITY DEFAULT '0',
 "sender" VARCHAR(50),
 "receiver" VARCHAR(50),
 "msg" VARCHAR(320),
 "senttime" VARCHAR(100),
 "receivedtime" VARCHAR(100),
 "reference" VARCHAR(100),
 "status" VARCHAR(50),
 "msgtype" VARCHAR(160),
 "operator" VARCHAR(100),
 "errormsg" VARCHAR(250),
 PRIMARY KEY ("id")
);

  1. Step: In SQL menu click on Execute all SQL statements option
  2. Step: Start Ozeki NG SMS Gateway and create a database user
  3. Step: Set Connection string type to OleDb and insert the connection string in Database connection tab

Provider=PervasiveOLEDB.;Data Source=DataBaseName;User
ID=UserName;Location=DBHostName;Persist Security Info=False

In this example I used the following parameters (Figure 1):

  • Database name: OZEKI
  • Username: test
  • Location: localhost

In the connection string please specify YOUR values.


Figure 1 - Specify connection string

More information





Next page: Date Format Strings
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > Pervasive SQL
Legal | Privacy | Terms of use | 2682
35.170.78.142 | 87.229.102.173 | Login