How to setup SQL EXPRESS database connection
This chapter will show you how you can connect to your own MSSQL Express or MSSQL Server through SQL EXPRESS connection. Via MSSQL it is possible to connect to different types of database servers. If the connection is successful, you can import contacts from your database to the Ozeki Bulk Messenger Software.
Step 1 - Create new database connection
The first step to create a connection between the Ozeki Gateway and the MSSQL software pack, is to Create a new Connection with the dedicated button on the upper side of the window. You can see where to click on Figure 1.
Step 2 - Type of database
Now you need to choose what is the connection method you wish to create. In this case you would want to connect to an app. To do that, click the Application button as you can see on Figure 2.
Now you need to choose the type of application you wish to connect to. MSSQL is a database management tool, so you need to choose the Database option. Click the dedicated button located on the right side of the screen. On Figure 3, you could see which button you need to click
In this step, you need to choose what would you like to use the connection for. In this scenario, you want to use it for communication, so please choose the SQL messaging option. Click the button that you can see on Figure 4.
In this step, you need to choose which Database Management software you would like to connect to. In this case this software is the MS SQL Express.
Step 3 - Database connection details
There are two possible ways for giving the details: 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 connection string under the Advanced menu: Server=192.168.0.113\SQLEXPRESS; Database=ozeki; User Id=ozekiuser; Password=qwe123;
- In connection string you have to give the availability of the server computer after the server. [IP address or hostname and the name of the ms sql server after \ (backslash)]
- Database: give your database name
- User Id: give your id
- Password: give your own password
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
You could use the event log to see every action that is happening on the connection. It means that in case of a successful connection, you will see the log registration for it, as you can see on Figure 8.
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.
More information
- How to setup ODBC database connection
- How to setup OLEDB database connection
- How to setup OLEDB database connection
- How to setup SQL EXPRESS database connection
- How to setup Oracle database connection
- How to setup Microsoft Access database connection
- How to setup DB2 database connection
- How to setup PostgreSQL database connection
- How to setup an Informix database connection
- How to setup SQL Anywhere database connection