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 10 SMS Gateway

How to send SMS from SQLite

install sqlite odbc driver
Figure 1 - Install SQLite ODBC driver

install sql messaging user
Figure 2 - Install SQL messaging user

add odbc connection
Figure 3 - Add ODBC connection

set odbc connection name
Figure 4 - Set ODBC connection name

Figure 5 - Provide the custom Connection string

DRIVER=SQLite3 ODBC Driver;Database=C:\sqlite\ozeki.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;

provide database file location
Figure 6 - Provide database file location

enable logging
Figure 7 - Enable logging

database connection established
Figure 8 - Database connection established

create ozekimessagein table
Figure 9 - Create ozekimessagein table

CREATE TABLE ozekimessagein (
	id INTEGER PRIMARY KEY,
  	sender varchar(255) default NULL,
  	receiver varchar(255) default NULL,
  	msg text default NULL,
  	senttime varchar(100) default NULL,
  	receivedtime varchar(100) default NULL,
  	operator varchar(100) default NULL,
  	msgtype varchar(160) default NULL,
  	reference varchar(100) default NULL
  	);

create ozekimessageout table
Figure 10 - Create ozekimessageout table

CREATE TABLE ozekimessageout (
  	id INTEGER PRIMARY KEY,
  	sender varchar(255) default NULL,
  	receiver varchar(255) default NULL,
  	msg text default NULL,
  	senttime varchar(100) default NULL,
  	receivedtime varchar(100) default NULL,
  	reference varchar(100) default NULL,
  	status varchar(20) default NULL,
  	msgtype varchar(160) default NULL,
  	operator varchar(100) default NULL,
  	errormsg varchar(250) default NULL
  	);	

create smpp client connection
Figure 11 - Create SMPP client connection

configure smpp client connection
Figure 12 - Configure SMPP client connection

sms message received
Figure 13 - SMS message received

message inserted into database
Figure 14 - Message inserted into database

check message in database
Figure 15 - Check message in database

send sms from the database
Figure 16 - Send SMS from the database

message sent from the database
Figure 17 - Message sent from the database

More information