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 Bulk Messenger software.

Step 1 - Start ODBC Data Sources

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

create new connection
Figure 1 - Create new connection

Step 2 - Add an IBM INFORMIX ODBC DRIVER

Click 'Add...' (Figure 2)

create new connection
Figure 2 - Clicking 'Add...'

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

create new connection
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'.

create new connection
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).

create new connection
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.

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

Now click 'Apply' (Figure 7).

create new connection
Figure 7 - Clicking 'Apply

We will now go back to Ozeki Bulk Messenger.

Step 4 - Open ODBC database connection in Ozeki Bulk Messenger

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

create new connection
Figure 8 - Opening the 'Databases'

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

create new connection
Figure 9 - Selecting ODBC

Step 5 - Configure the ODBC connection in Ozeki Bulk Messenger

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

create new connection
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)

create new connection
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).

create new connection
Figure 12 - Clicking on 'SQL'

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

create new connection
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 Bulk Messenger. For example:
SELECT FullName, PhoneNumber, Email FROM People;

More information