Home
RECOMMENDED FOR YOU:
SMS Gateway software
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
Ozeki NG SMS Gateway

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(255),
 "receiver" VARCHAR(255),
 "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(255),
 "receiver" VARCHAR(255),
 "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