- Product Manual
- Introduction
- Installation Guide
- Prerequisites
- SMS technology
- Download Information
- Installation Steps
- GSM Modem Setup
- Mobile Network Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- MySQL
- Oracle
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- Access 365
- OleDb
- Access 2007
- Video
- Connection string builder
- Keywords
- MS SQL high speed
- Oracle High Speed
- SQL statements
- Polling technology
- Dynamic Keywords
- Dynamic SMPP parameters
- Autoreply SMS from database
- Autoreply SMS using a script
- Simple autoreply SMS
- SMS from or to file
- SMS through E-mail
- SMS via HTTP Request
- SMS via colour protocol
- Application starter SMS
- SMS Voting
- SMS from MS Outlook
- SMS from/to FTP server
- PDF Request in SMS
- SMS to WCF service
- SMS Forwarder
- RSS to SMS
- Linux
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android
C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code
PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website
SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
How to connect to Access 2007
On this page you will be provided with detailed information on how to connect to Access 2007 database. Follow the steps and screenshots below to configure this connection. Please find the connection string, as well.
Download the database used in the example: | ozeki_database.accdb |
Configuration steps
Before you start to configure your database connection, you need to create two database tables: "ozekimessagein" and "ozekimessageout". Figure 1 and Figure 2 demonstrate how these tables should be created.
Please note that in our example Access 2007 database is placed on the desktop (Figure 3).
Figure 4 demonstrates the path to Access 2007 database.
Now you need to install a database user in Ozeki NG SMS Gateway. You need to specify the database connection string for your database server. First select "OleDb" for "Connection string type". Then provide the following Connection string (Figure 5):
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=PathToYourDatabase;Persist Security Info=False
Please note that you need to provide the path to your database after "Data Source=" part in the connection string.
Then on "SQL for sending" tab you need to remove apostrophes around the $id keyword in all SQL templates (Figure 6).
This concludes the configuration of the connection.
Testing the configuration
To test the configuration insert a row Into "ozekimessageout" table with an SQL INSERT command. Click on "Execute" (Figure 7).
In the Outbox of the database user in Ozeki NG SMS Gateway you can see the sent message (Figure 8).
Figure 9 shows the incoming message for database user in Ozeki NG SMS Gateway.
Now to see the inserted rows, query all row from "ozekimessagein" table with an SQL SELECT command and click on "Execute" (Figure 10).
As a result of the SQL SELECT command, you can see the incoming message in Ozeki NG SMS Gateway (Figure 11).
More information