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 an Informix database connection

In this chapter you can learn how to connect to your Informix database through ODBC connection. Via ODBC you can connect to different types of database servers, because it is a general type of connection. If you have connected successfully, then you can import contacts from your Informix database to the Ozeki Dialer software.

Step 1 - Start ODBC Data Sources

First you need to search ODBC Data Sources from the Start menu (Figure 1)

Start ODBC Data Sources
Figure 1 - Starting ODBC Data Sources (64 bit)

Step 2 - Add an IBM INFORMIX ODBC DRIVER

Click 'Add...' (Figure 2)

Clicking 'Add...'
Figure 2 - Clicking 'Add...'

Choose 'IBM INFORMIX ODBC DRIVER (64-bit)' (Figure 3).

Selecting 'IBM INFORMIX ODBC DRIVER'
Figure 3 - Selecting 'IBM INFORMIX ODBC DRIVER (64-bit)'

Step 3 - Connect the ODBC DRIVER to your Informix database

You need to add a data source name (Figure 4). We called it 'Informix'.

Adding a 'Data Source Name'
Figure 4 - Adding a 'Data Source Name'

Now please fillout the connection details to your Informix database. When you are ready click 'Apply & Test Connection' (Figure 5).

Filling out the connection details
Figure 5 - Filling out the connection details

If you see the 'Test connection was successful.' messagebox (Figure 6) then it is sure that the IBM INFORMIX ODBC DRIVER can connect to your Informix database.

The 'Test connection was successful.' messagebox
Figure 6 - The 'Test connection was successful.' messagebox

Now click 'Apply' (Figure 7).

Clicking 'Apply'
Figure 7 - Clicking 'Apply'

We will now go back to Ozeki Dialer.

Step 4 - Open ODBC database connection in Ozeki Dialer

Click 'Databases' from the 'Setup' menu (Figure 8).

Opening the 'Databases'
Figure 8 - Opening the 'Databases'

Click on 'Create new database connection' and select 'ODBC' (Figure 9).

Selecting ODBC
Figure 9 - Selecting ODBC

Step 5 - Configure the ODBC connection in Ozeki Dialer

Fill out the connection details accurately and click 'Ok' (Figure 10). The driver is:
{IBM INFORMIX ODBC DRIVER (64-bit)}

Filling out the connection details
Figure 10 - Filling out the connection details

Step 6 - Testing out the database connection

You will see a green tick if everything went fine. Now click 'Open' to test the database connection. (Figure 11)

You can see the database connection online
Figure 11 - You can see the database connection online, now you can click 'Open'

You can test the database by using SQL code so click on 'SQL' to continue (Figure 12).

Clicking on 'SQL'
Figure 12 - Clicking on 'SQL'

You can write your own codes or you can find example codes in Ozeki Dialer. Click 'Execute' to run the code on your Informix database. (Figure 13)

Creating a table called 'People' in your Informix database
Figure 13 - Creating a table called 'People' in your Informix database

By selecting queries from your tables, you can create your SQL addressbooks in Ozeki Dialer. For example:
SELECT FullName, PhoneNumber, Email FROM People;


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