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 (
CREATE TABLE ozekimessagein (
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 !
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!