Products
Ozeki 10
SMS
Ozeki NG SMS Gateway
Message Server 6
On-line manual
Introduction
SMS technology
MMS technology
About
Product features
Installation guide
Server
Prerequisites
Installation steps
Product Activation
Server Preferences
Drivers
Plugins
Colour SMS
Database (SQL)
ODBC configuration
Service account
Microsoft-SQL
Backward compatibility
MyODBC driver
Files
HTTP Client
PHP
POP3/SMTP connection
POP3
SMTP
TCP/IP
Appstarter
Autoreply
Tester
User accounts
Upgrade
Server port
Clients
System maintenance
User guide
Developers guide
Case studies
Appendix
Download
Home
Support
How to buy
SMS Wall
IP SMS Gateway
Android SMS
Excel SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Installer
Technology
Company


On-line manual:
  Explore all the features in this On-line HTML documentation of Ozeki Message Server 6.

Product guide:
  Download Ozeki Message Server 6 Manual in PDF format. This PDF guide explains all the features of Ozeki Message Server 6.
Ozeki Message Server 6
Backward compatibility Backward compatibility | Files Files

Installation of ODBC database drivers

Almost every database server has an ODBC driver, that makes connection to it possible. In this document we explain the basic steps of connecting the Ozeki SMS gateway  to a database server. In the example the MySQL ODBC driver is used. The MySQL ODBC driver is an excellent way to connect to MySQL database servers.

To install a MySQL ODBC connection, first you need to download and install the MySQL ODBC driver from the following URL:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

This ODBC driver is called: MyODBC. After the driver has been installed, the ODBC adminstrator (Sometimes Data Sources) form needs to be opened using the "Administrative Tools" in the control panel (Figure 1.)

Figure 1 - Opening the ODBC administrator.

In the ODBC datasource administrator form you can click on the Add button, and select that driver,  you want to install.
(In our case we need to choose MySQL ODBC driver) (Figure 2).

Figure 2 - selecting the MyODBC driver.

When the driver is selected a custom (ODBC driver specific) configuration comes up. On this custom configuration form please enter the appropriate connection information (Figure 3.)

Figure 3 - Custom ODBC driver configuration form.

After the  ODBC driver has been installed and configurated. We need to open the Ozeki Message Server Manager Interface, to configure the newly created ODBC Data source. In the Ozeki Message Server Manager, please install the database plugin. (Figure 4.) 

Figure 4 - database plugin installation.

After installation, you need to click on the database plugin 1 configuration link , that brings up the configuration form. On this form  you have to click on the Connection information tab. On this tab  please enter the following ADO connection string:

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=ozekisms;User=root;Password=abc123;Option=4;

 

Figure 5. - Building the database connection

 


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > SMS > Message Server 6 > On-line manual > Installation guide > Server > Plugins > Database (SQL) > MyODBC driver
Legal | Privacy policy | Terms of use
Page: 625 | Login | 18.205.176.85