Products
Technology
SMS solutions
PBX systems
Databases
ODBC
OleDB
MySQL
MySQL ODBC
MS SQL
Oracle
Microsoft Access
DB2
PostgreSQL
Informix
SQL Anywhere
Robotics
Company


How to setup MySQL database connection

In this chapter you can learn how to connect to a given database. This step shows you how you can import contacts from your own database to the Ozeki Bulk Messenger software.

Step 1 - Create new database connection

In this chapter you can learn how to connect to your MySQL database.

Create new database connection
Figure 1 - Create new database connection

Step 2 - Type of database

With our software solution you can connect to several types of database servers.
In this case you have to select MySQL. Click to the icon.

MySQL
Figure 2 - Click to MySQL

Step 3 - Database connection details


There are two options for this: you can give the data below the General menu, or you can give the connection string below the Advanced menu. In case you give the connection string, it overwrites the data given below the General menu.

  • Server: The IP address of the database server (e.g. 192.168.112.121).
  • Database: The name of the database that stores the contacts (e.g. ozeki).
  • User: The username with which you can connect to the database (e.g. ozeki).
  • Password: The password that belongs to the previously given username (e.g. ozeki).

Database Connection Details
Figure 3 - Connection settings

In this example we give the connection string under the Advanced menu
You can use the following connection string:
Server=192.168.112.121; Database=ozeki; Uid=ozeki; Pwd=ozeki;

If the connection is successful, a green tick will appear under State.
Click to the Open button to go to the details page of this connection

Database Connections
Figure 5 - Click to Open

The event log will show you if you have connected successfully

Check the data below Event log

Event Log
Figure 6 - Event log

Step 4 - Testing the database connection

If you click to the Test button, you can give the database table in which you store your contact lists.
Click to the Execute button to list the phone numbers that are stored in the given database's table.

Select from my table
Figure 7 - Test the database


Copyright © 2000- - Ozeki Informatics Ltd. | info@ozeki.hu | Tel: +36 1 371 0150
Home > Technology > Databases > MySQL
Page: 1498 | Login