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


How to setup OLEDB database connection

This chapter will show you how you can connect to your own database through OLEDB connection. Via OLEDB it is possible to connect to different types of database servers. In the following you will connect to the MS SQL Server. If the connection is successful, you can import contacts from your database to the Ozeki Dialer Software.

Step 1 - Create new database connection

This step shows you how to create new database connection. Click to the given button.

Create new database connection
Figure 1 - Create new database connection

Step 2 - Type of database

Select the type of the database, which you wish to use. The following figure shows you how you can do it. Click to OLEDB for the next step.

OLEDB
Figure 2 - Click to OLEDB

Before you perform the next step, a special driver needs to be installed so the OLEDB connection can be built-up successfully. The OLEDB driver database can vary in each servers. You need to install the SQL SERVER NATIVE CLIENT driver to support the MS SQL Server.

Step 3 - Database connection details

There are two possible ways 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.

In this example we give the following connection string under the Advanced menu:
Provider=SQLNCLI11;Server=DESKTOP-4SIRROH\SQLEXPRESS;Database=ozeki;Uid=sa;Pwd=qwe123;
  • Provider: the name of the provider that is installed on the PC where Ozeki Dialer is installed (e.g. SQLNCLI11 = sql server native client version 11).
  • Server: the server's details [IP or hostname plus \ (backslash), then the SQL server's name] (e.g. DESKTOP-4SIRROH\SQLEXPRESS)
  • Database: the name of the database (e.g. ozeki).
  • User id: the name of the user who can access the database (e.g. sa).
  • Password: the password of the previously provider username (e.g. qwe123).

Advanced
Figure 3 - Connection settings

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

Open
Figure 4 - Click to Open

The event log will show you if you have connected successfully
Check the data below Event log

Event log
Figure 5 - 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.

Test
Figure 6 - Test the database


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