Welcome page
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
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
Database (SQL) Database (SQL) | Service account Service account

ODBC DRIVER INSTALLATION

To configure database connectivity in Ozeki Message Server, you need to set up an ADO and ODBC driver. This page gives you detailed information if you wish to install and configure the MySQL  ODBC driver called MyODBC. The installation of other database drivers are similar to this installatin.

MyODBC installation and configuration.

Step 1
Download the MyODBC database driver from the Internet.You can use the following link:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

Step 2
Install the downloaded MyODBC database driver by starting the downloaded exe file. The installation is similar to the installation of any windows application. Click on the Next and Ok buttons.

Step 3
If the driver is available on your system, you need to set up a datasource. Go to Control Panel and then click on Administrative Tools and then click on the   Data Sources (ODBC) icon.

Figure 1. - D atasource administrator

This will open the data source administrator, which is part of Windows (Figure 1). In the datasource administrator, you must define a datasource. Click on User DSN Tab (it is the default tab) and click Add as shown in the figure above. The will bring up the "Create New Datasource" form (Figure 2).

Figure 2. - Create new datasource

On this form you need to select the newly installed driver and click on Finish. In most cases when you click on Finish a database server specific configuration form comes up. On this form specify the database that can be used by Ozeki Message Server.  

Figure 3 - Database driver configuration

In case of MyODBC, enter the details as can be seen in Figure 3. (In the database name enter your database name) and after filling in all the proper fields click on the Test Data Source  to check if you have properly configured your Database settings.

If the test connection succeeds, it means you have a working datasource, that can be attached to Ozeki Message Server.

Copyright © 2000- - Ozeki Ltd | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > SMS > Message Server 6 > On-line manual > Installation guide > Server > Plugins > Database (SQL) > ODBC configuration
Legal | Privacy policy | Terms of use
Page: 183 | Login | 3.80.177.176