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 connectionThis step shows you how to create new database connection. Click to the given button.
Step 2 - Type of databaseSelect 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.
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 detailsThere 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:
If the connection is successful, a green tick will appear under State.
The event log will show you if you have connected successfully
Step 4 - Testing the database connectionIf 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.