- MySQL ODBC
- MS SQL
- Microsoft Access
- SQL Anywhere
- PBX systems
- Upload Arduino code
How to setup MySQL database connection
Step 1 - Create new database connectionIn this chapter you can learn how to connect to your MySQL database.
Figure 1 - Create new database connection
Step 2 - Type of databaseWith our software solution you can connect to several types of database servers.
In this case you have to select MySQL. Click to the icon.
Figure 2 - Click to MySQL
Step 3 - Database connection details
There are two options 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.
- Server: The IP address of the database server (e.g. 192.168.112.121).
- Database: The name of the database that stores the contacts (e.g. ozeki).
- User: The username with which you can connect to the database (e.g. ozeki).
- Password: The password that belongs to the previously given username (e.g. ozeki).
Figure 3 - Connection settings
In this example we give the connection string under the Advanced menu
You can use the following connection string:
Server=192.168.112.121; Database=ozeki; Uid=ozeki; Pwd=ozeki;
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 5 - Click to Open
The event log will show you if you have connected successfullyCheck the data below Event log
Figure 6 - 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 7 - Test the database