- Product Manual
- Introduction
- Installation Guide
- Prerequisites
- SMS technology
- Download Information
- Installation Steps
- GSM Modem Setup
- Service Provider Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- MySQL
- MyODBC v8
- Database layout
- MyODBC driver installation
- Oracle
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- 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/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
MyODBC Driver Installation and Configuration
On this page you can find out how to install and configure a MyODBC 8 driver for Ozeki NG - SMS Gateway to allow SMS messaging.
To configure database connectivity in Ozeki NG - SMS Gateway, you need to set up an ODBC driver. To install and configure a MyODBC driver (for a MySQL database), follow the instructions below. The installation and configuration of other database drivers is similar to the process described here.
Download the MyODBC database driver from the Internet. You can use the following link: http://dev.mysql.com/downloads/connector/odbc/
Install the downloaded MyODBC database driver by starting the downloaded exe file. The installation is similar to the installation of any Windows application. Click the Next and the OK button to get from one dialog box to the next and to finish the installation.
When the driver is available on your system, you need to set up a data source. Open Start menu and start typing ODBC. The first result should be the ODBC Data Source. Click it to open the ODBC Data Source Administrator panel, which is part of Windows (Figure 1).
In the ODBC Data Source Administrator panel, you have to define a datasource. Click the User DSN Tab (it is the default tab), and click Add as shown in the figure below. This will bring up the "Create New Datasource" dialog box (Figure 2).
In this form (Figure 3) select the (newly installed) driver, and click Finish. In most cases, when you click Finish, a database server specific configuration form comes up. (You can also open this configuration form by double-clicking the selected driver.)
In the database configurator, which can be seen on Figure 4, you need to provide the following data:
- In the Data Source Name box, enter the name of
the data source you want to access. It can be any valid name that you choose.
- In the Port box, enter the port number if it is not the default (3306).
- In the User box, enter your MySQL username (your database user ID).
- In the Password box, enter your password.
- In the Database dropdown menu, select the database to be current upon connect
When configuring a MySQL database user in Ozeki NG - SMS Gateway, you have to specify the database connection string in the Database connection tab. Include the configuration specifications of your ODBC driver in the connection string (Figure 5).
For more information about the configuration of a MySQL user for SMS messaging using Ozeki NG - SMS Gateway, check out the MySQL User page.
You can find database connection strings for a wide range of different databases In Appendix B - Connection Strings.
More information
- MySQL User
- Appendix B - Connection Strings
- Database User
- MyODBC v5
- Database layout
- MyODBC drivers installation
- FAQ