Ozeki 10 SMS Gateway

Microsoft Access 2013

You will see detailed information on this page to show how to send and receive SMS messages with Microsoft Access 2013 database tables. Please follow these steps and screenshots to configure the connection to perfectly read lines from the outgoing message table and paste lines to the incoming message table. The default table names are 'ozekimessagein' and 'ozekimessageout'.

On the previous page you might have read how to connect to the Access 2013 database and set the SQL statements, but on this page you can see it from the aspect of your Microsoft Access database. At the bottom of this page you can see how to send and receive messages with simple examples.

This example contains a database which you can download from here: ozeki_database.accdb

How to connect SMS Gateway
to this Access database example

After you have downloaded 'ozeki_database.accdb', please place it to a selected folder. In this tutorial it have been saved to the desktop (Figure 1) Although you can save it to any other location.

Figure 1 - ozeki_database.accdb placed on the laptop

Please memorize the file's location. Later on you will have to use this path in the connection string. You can check the path from the 'File Explorer' (Figure 2). The file is an Access 2013 database file.

Figure 2 - Save the path to your database. This will be useful for creating the connection string.

Just before you start configuring your database connection, please create these two database tables: 'ozekimessagein' and 'ozekimessageout' (Figure 3 and Figure 4).

Figure 3 - 'ozekimessagein' table in Microsoft Access database

Figure 4 - 'ozekimessageout' table in Microsoft Access database

It is assumed that you have already created the Database User. The Database User can be installed on your Ozeki SMS Gateway. Please select 'Oledb' and specify the database connection string to your Access database, which should look the following way:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=PathToYourDatabase;Persist Security Info=False
Figure 5 - OLE DB connection string to an Access database

Keep in mind to change the 'Data Source=' parameter to the location of 'ozeki_database.accdb' (Figure 6).

Figure 6 - Paste your database connection string at the Database User's configuration panel

Switch to the 'SQL for sending' and 'SQL for receiving' tabpages and remove the apostrophes (' ') around $id (Figure 7) and remove it from around all other attributes starting with a $ sign.

Figure 7 - Remove apostrophes from all of the UPDATE statements

Now it is ready to use the configuration of the connection.

Testing the configuration

When testing, you should use both tables. The one which was created for incoming messages and the one which was created for outgoing messages. In these examples these tables are called 'ozekimessageout' and 'ozekimessagein'.

Sending messages

To test the configuration, you should INSERT a message record into the outgoing messages table (Figure 8), which is called 'ozekimessageout' in the current example. These messages can be SELECT-ed (polled) by configuring the Database User here:
'SQL for sending' tabpage and 'Polling' sub-tabpage. Please search these options in the SMS Gateway's browser GUI.

Figure 8 - INSERT a new row into the outgoing message table

The 'status=' parameter of the message record will change from 'Sending' to 'Sent' to 'Delivered'. The sent message will be visible in the Database User's Outbox folder (Figure 9).

Figure 9 - The test message have been sent

Receiving messages

If an incoming message log event is displayed in the Database User's event log (Figure 10), the message entry will be INSERT -ed in the incoming message database table. The INSERT statement can be configured in the 'SQL for receiving' tabpage of this Database User's configuration panel. This is the statement which INSERT-s incoming messages.

Figure 10 - Message is received by Ozeki SMS Gateway. Your Database User will INSERT it into a table.

In this example the incoming message table is called 'ozekimessagein'. This is where those SMS messages are INSERT-ed, which are received by the Database User. You should run a SELECT statement on it (Figure 11) to read all of the messages (Figure 12).

Figure 11 - SELECT messages from the incoming message table

All of the incoming messages can be read after running a SELECT query on 'ozekimessagein' (Figure 12).

Figure 12 - The SMS messages received by Ozeki SMS Gateway's Database User

Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > SMS > SMS gateway > SMS from/to Database > Microsoft Access > Access 2013
Legal | Privacy policy | Terms of use
Page: 5801 | Login |