- MS SQL
- Microsoft Access
- SQL Anywhere
- PBX systems
- Upload Arduino code
How to setup OLEDB database connection
Step 1 - Create new database connectionThis step shows you how to create new database connection. Click to the given button.
Figure 1 - Create new database connection
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.
Figure 2 - Click to OLEDB
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:
- Provider: the name of the provider that is installed on the PC where Ozeki Bulk Messenger is installed (e.g. SQLNCLI11 = sql server native client version 11).
- Server: 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: the name of the user who can access the database (e.g. sa).
- Password: the password of the previously provider username (e.g. qwe123).
Figure 3 - 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
Figure 4 - Click to Open
The event log will show you if you have connected successfully
Check the data below Event log
Figure 5 - Event log
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.
Figure 6 - Test the database