How to setup ODBC database connection
In this chapter you can learn how to connect to your 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 database to the Ozeki Bulk Messenger Software.
Step 1 - Create new database connectionIn this step you can see how to create a new database connection. First you need to click on Create new database connection button.
Step 2 - Type of databaseWith Ozeki Bulk Messenger software solution it is possible to connect to different types of database servers. In the following figure you can see on which button you need to click to install a new ODBC connection.
Before you perform the next step, a special driver needs to be installed
so the ODBC connection will be built-up successfully.
The ODBC driver database can vary in each servers, you can find an example of MySQL on the next page.
Step 3 - Database connection detailsThere are two 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 data under the General menu:
If the connection is successful, a green tick will appear under State. Click to Open button to go to the details page of this connection.
In case of unsuccessfull connection the event log
will show you the problems with the exact error message.
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.