Products
Technology
SMS solutions
PBX systems
Databases
ODBC
OleDB
MySQL
MS SQL
Oracle
Microsoft Access
DB2
PostgreSQL
Informix
SQL Anywhere
Robotics
Company


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 Dialer Software.

Step 1 - Create new database connection

This is the very first step you have to do to create a new database connection. First you need to click on the Create new database connection button.

Create new database connection
Figure 1 - Create new database connection

Step 2 - Type of database

Ozeki Dialer software solution gives you the opportunity 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 SQLExpress connection.

SQL
Figure 2 - Click to 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=DESKTOP-4SIRROH\SQLEXPRESS; Database=ozeki; User Id=sa; 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

Advanced
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

Event log
Figure 4 - Click to Open

The event log will show you if you have connected successfully.
Check the data below Event log

Successfully connected
Figure 5 - Event log

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.

Select from my table
Figure 6 - Test the database


Copyright © 2000- - Ozeki Informatics Ltd. | info@ozeki.hu | Tel: +36 1 371 0150
Home > Technology > Databases > MS SQL
Page: 1499