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

Step 1 - Create new database connection

To establish a connection, click the Create new Connection button located on the upper side of the screen. On Figure 1, you can see which button you need to click.

create new connection
Figure 1 - Create new connection

Step 2 - Type of database

Now you get to choose the connection method. You have 5 options you could choose. The suitable option for the OLEDB database connection is the Application method. Click it to proceed to the next step.

connection method
Figure 2 - Connection method

Here, you get to choose what type of application you wish to use with the connection channel. The suitable option is the database one. Click it to proceed to the next step. You could see your option and what to choose on Figure 3.

application type
Figure 3 - Application type

On the final configuration step, you get to choose the type of database you wish to use with the connection. Please select the SQL messaging option here. Click the button and proceed to the next step. You could see which one to choose on Figure 4.

sql messaging
Figure 4 - SQL messaging

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.

Here, you get to choose which type of SQL Database Management tool you wish to use with the connection. To use the connection with the OLEDB Database management tool, use the OLEDB option. Click the blue install button to proceed to the next step. You can see more information about the connection on Figure 5.

install oledb
Figure 5 - Install OLEDB

Step 3 - Database connection details

There are two possible ways for this: you can give the data below the General menu,

In this example we give the following connection string under the Advanced menu:
Provider=SQLOLEDB; Server=DESKTOP-4SIRROH\SQLEXPRESS; Database=ozeki; Uid=ozekiuser; Pwd=qwe123;

  • Password: the password of the previously provider username (e.g. qwe123).
  • Provider: the name of the provider that is installed on the PC where Ozeki Bulk Messenger is installed (e.g. SQLOLEDB).
  • Data Source: 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: ozekiuser.

oledb connection settings
Figure 6 - OLEDB 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

click to open details page of connection
Figure 7 - Click to open

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

event log
Figure 8 - 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 the database
Figure 9 - Test the database

More information