- Product Manual
- Introduction
- Installation Guide
- Prerequisites
- SMS technology
- Download Information
- Installation Steps
- GSM Modem Setup
- Mobile Network Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- MySQL
- Oracle
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- Video
- Connection string builder
- Keywords
- MS SQL high speed
- Oracle High Speed
- SQL statements
- Polling technology
- Dynamic Keywords
- Dynamic SMPP parameters
- Autoreply SMS from database
- Autoreply SMS using a script
- Simple autoreply SMS
- SMS from or to file
- SMS through E-mail
- SMS via HTTP Request
- SMS via colour protocol
- Application starter SMS
- SMS Voting
- SMS from MS Outlook
- SMS from/to FTP server
- PDF Request in SMS
- SMS to WCF service
- SMS Forwarder
- RSS to SMS
- Linux
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
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 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.
- Step: Install Pervasive SQL
- Step: Start Pervasive Control Center and Documentation
- Step: Click on Create a new SQL document option
- Step: Select the database in which you wish to create database tables
- 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") ); |
- Step: In SQL menu click on Execute all SQL statements option
- Step: Start Ozeki NG SMS Gateway and create a database user
- 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.
More information
- Quick start guide for Ozeki NG SMS Gateway
- GSM modem connection
- IP SMS connection
- How to create database user in the SMS gateway