Products
Ozeki 10
Apps
Chat
SMS Gateway
SMS with Client Software
HTTP API
SMS from/to Database
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
System Database
MySQL
Oracle
MSSQL 2008
MSSQL 2012/2014
Import messages
Switch from file
Robot Controller
Softphone
Connections
Installation guide
Terms and Definitions
SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Technology
Company


Ozeki SMS Gateway
SQL Logging SQL Logging | MySQL MySQL

System Database Configuration

Storing messages in files and forwarding them afterwards can be time consuming with an average office computer, but databases offer a quite faster solution combined with SMS Gateway's power.

Find out how to connect your Ozeki SMS Gateway to your database for receiving and sending messages and how to use the database to store delivery logs for outgoing messages. If you have previously stored messages in user files, you should import them.

Start the video

This page shows only the most basic steps to create your database connection. If you are familiar with Ozeki 10's SMS Gateway this would be enough. For further instructions please check the following subpages:

These subpages show how to connect various types of database servers to Ozeki SMS Gateway and how to import the preferred SMS Gateway user files to your freshly connected database server.

The most Basic Steps

You should start by running Ozeki SMS Gateway from Ozeki 10's desktop and clicking 'Edit/Server preferences' from the top menu of your SMS Gateway (Figure 1).


Figure 1 - Click 'Edit/Server preferences' on SMS Gateway's top menu

A new form should open up. Please select the 'Database/System database settings' tabpages on the form (Figure 2). Do not forget to tick the 'Use a database server instead of file system to store messages' checkbox. Then please specify the 'Database connection type' you are using at your company and add the connection string of your database connection driver. You can also check the different type of database statements belonging to different type of message actions.


Figure 2 - Selecting 'Database/System database settings'

Keep in mind

You can receive an error if the system cannot find the messages. The reason for this is very simple: The system still searches them in the file, instead of searching them on your SQL database.


Copyright © 2000- - Ozeki Informatics Ltd. | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > Ozeki 10 > Apps > SMS Gateway > System Database
Page: 5792 | Login