Welcome page
Products
Ozeki 10
SMS
Ozeki NG SMS Gateway
Message Server 6
On-line manual
Introduction
SMS technology
MMS technology
About
Product features
Installation guide
Server
Prerequisites
Installation steps
Product Activation
Server Preferences
Drivers
Plugins
Colour SMS
Database (SQL)
ODBC configuration
Service account
Microsoft-SQL
Backward compatibility
MyODBC driver
Files
HTTP Client
PHP
POP3/SMTP connection
POP3
SMTP
TCP/IP
Appstarter
Autoreply
Tester
User accounts
Upgrade
Server port
Clients
System maintenance
User guide
Developers guide
Case studies
Appendix
Download
Home
Support
How to buy
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Technology
Company


On-line manual:
  Explore all the features in this On-line HTML documentation of Ozeki Message Server 6.

Product guide:
  Download Ozeki Message Server 6 Manual in PDF format. This PDF guide explains all the features of Ozeki Message Server 6.
Ozeki Message Server 6
Service account Service account | Backward compatibility Backward compatibility

SENDING AND RECEIVING SMS MESSAGES USING A MICROSOFT SQL DATABASE SERVER

Under construction!!! check

If you use the Ozeki Message Server,   you can send and receive SMS messages using a database server with the help of SQL queries. In order to use this option, you need to have a database server MS SQL installed, and there should be two database tables created: ozekimessageout and ozekimessagein. One of these will be used for sending and the other for receiving SMS messages.

Reqire to install the MS SQL database server software.

Step 1: Configure the MS-SQL database

Summary: 1. start the service, 2. start a SQL Querry, 3. create DB, 4 Check  the DB exist

If the MS-SQL service did not start automatically, you set up   the Service Manager and click on   the Service Manager  (Figure ). Click on  , and find the Microsoft SQL Server menuitem, and click on Service Manager. After a window opens up: SQL Server Manager. It can be found at t he bottom of the window (Figure 1).

Figure 1 - SQL Server Service Manager

 

Start  the Query Analiser, Select on  / Programs / Microsoft SQL Server / and click on Query Analiser. After this a   window opens (Figure 2).

Figure 2 - Query Analiser

Click on the File menu, select Connect menu item. In the dropdown of the SQL Server  menu, select the SQL server IP address.  T ype the local IP address, because the SQL Server and the Ozeki Message Server are on the same computer. Place a checkmark into the " Start SQL Server, if it stopped" checkbox. Select the Use Windows NT authentication radio button. Click OK (Figure 3).

Figure 3 - Connection to SQL server

The following window opens SQL Server Query Analyser. In the DB dropdown menu database can be selected. Default is master (Figure 4).

Figure 4 - SQL Server Query Analyzer

The next form shows , how to create SQL database for Ozeki Message Server. It can be done easy. Just Copy-Paste the script into the Querry Analyser.

The SQL Script (case sensitive):

CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg varchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),
);

CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg varchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),
);

When the script is placed to the Query Analyzer, c lick on parse icon . It checks the SQL script errors. If there were no errors  found, you will show The command(s) completed successfully. Click on execute icon . SQL Query return The command(s)  completed successfully. (Figure 5  ) The SQL databese was created!

Figure 5 - Running of the commands

To understand what's happened:  

(The  "SELECT * FROM ozekimessageout" list the columns of the ozekimessageout table.)

 Before the SQL script was ran:  (Figure 6 )

SQL Querry return an error, because the databases are empty. 

Figure 6 - Running SQL script

After the script was ran correctly, it means, that   DB and tables were created successfully:

The arrows show the created colums (id, sender,...) (Figure 7 ).

Figure 7 - Creating columns

You have a created MS-SQL DataBase !


Step 2 : Configure Ozeki Message Server

Go to the Plugins menu and select Installed Plugins menu item (Figure 8 ).

.

Figure 8 - Installing plugins

Click on Install, which is next to Database Plugin (Figure 9).

Figure 9 - Installing the database plugin

When the Plugin installed, click on Configure (Figure 10 ).

Figure 10 - Configuration

Place a check mark into the checkbox of Use Database for receiving SMS message . (2) It means, that the incoming SMS stored in the Database. Place a checkmark into the checkbox of Use Database for receiving SMS message (3). Place a checkmark into checkbox of Autoconnect on startup . When the Ozeki Message Server starts, then  the database connection will be established. Click on Build database connection (1). (Figure 11 ).

Figure 11 - Connection information tab

 

Select the Use Connection String radio button. Click on Build. (Figure 12 ).

Figure 12 - Connection string

 

Data Link Properities screen opens up. In t he OLE DB providers list box, you have to  select the Microsoft OLE DB Provider for SQL server. Click on Next. (Figure 13 ).

Figure 13 - Pointing out the data in the Data Link Properties tab

Click on the Connection tab. In the Select or enter a server name combo box, you have to  write the MS-SQL server IP address. (1) The MS-SQL server and the Ozeki Message Server are running on the same computer, so the IP address is 127.0.0.1 . Select " Use a specific user name and password" radio button and write sa the input field. (2) 'Sa' is the default. Place a checkmark  into the checkbox of Blank password . Choose Select the database on the server radio button and select master item in the combo box (3) (Figure 14).

Figure 14 - Configuration in the Provider tab

Message Server was configured successfully : Click on Connect (1) and Refresh this page (2) (Figure 15).

Figure 15 - Configuration

As a last step,  configure the Ozeki Message Server with MS-SQL database!

 


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > SMS > Message Server 6 > On-line manual > Installation guide > Server > Plugins > Database (SQL) > Microsoft-SQL
Legal | Privacy policy | Terms of use
Page: 576 | Login | 54.80.87.166