- Quick start guide
- System requirements
- Installation guide
- Mobile networks
- User guide
- Developers guide
- SMS from SQL
- MSSQL SMS
- Oracle SMS
- MySQL SMS
- SQL Anywhere
- Microsoft Access
- Access 2013
- HTTP API
- PHP SMS API
- C# SMS API
- VB.NET SMS API
- Service providers
SMS from/to Microsoft Access
You can simply start to send and receive SMS messages through Ozeki SMS Gateway's Database User by using Microsoft Access database tables. All you have to do is insert or read data rows from the appropriate SQL table by configuring INSERT INTO and SELECT statements for the user.
This page shows how to install and prepare the Database User in the browser GUI of Ozeki SMS Gateway. Additionally on the next page you can simply see how to use Microsoft Access with a few easy screenshots.
Basics of Microsoft Access connection
The Database User can connect to your Access database tables. Keep in mind to create two tables. One for receiving and the other one for sending messages. The table structure should match the one in the MS SQL configuration, which basically consists of an ozekimessagein and ozekimessageout table. Finally you should write SQL statements to work with these tables. At the bottom of the page you can find some UPDATE statements to use on the sent message records.
Add Database User
Make sure that your Ozeki SMS Gateway is connected to your GSM modem or IP SMS service provider. For example SMPP, CIMD2 or UCP/EMI are accepted service provider connections. After you are able to manually send and receive SMS messages with SMS Gateway, you can install (Figure 1) and configure a Database User as you can see below.
You should start by selecting 'Users and applications/Add new user or application' from the top menu then search the SQL messaging User and and then select the MS Access user. Click the blue 'install' button next to it as you can see on Figure 1.
Figure 1 - Start installing your SMS Gateway's Database User
Configure Database User
Database User is highly advised to connect to the most common databases. Here you can find the list of supported databases. After using a connection string to connect to your database, you can set which SQL statements to use in Ozeki SMS Gateway.
Connect to your Microsoft Access database with the help of an ODBC connection string, which points to your database through your ODBC driver. Please type the path of the database file as seen on Figure 2.
Figure 2 - Configure the database connection settings
Set SQL templates
After setting the connection string, it is time to set the SQL templates. These statements are required to update the outgoing message table, which is most likely called 'ozekimessageout'. The default statements in Ozeki SMS Gateway will not work with Microsoft Access databases. This is why you are highly suggested to check the following figures to make some minor changes like moving the apostrophe (' ') surrounding the $id keyword.
Figure 3 - Sending template UPDATE-s your message in ozekimessageout
Congratulation! You have properly configured Ozeki SMS Gateway to send SMS messages from your Microsoft Access database. You are recommended to test it by INSERT-ing your first SMS message to your outgoing message table. The SMS Gateway's Database User is capable to read these message record and update them as described above from Figure 3. Please jump to the Microsoft Access 2013 tutorial for details.