Database Connection Settings

Content

1. Introduction

2. Setup Database Connection Settings

2.1 Microsoft Access

2.2 Oracle

2.3 Microsoft SQL Server

2.4 MySQL

1.Introduction

The SMSgee software using OLE-DB interface to communicating with the external database.

Most Database have OLE-DB driver (picture 1) , if the Database doesn't have any OLE-DB driver, could be using ODBC driver to mediate between Database and OLE DB Interface(picture 2) , for example : MySQL

Picture 1. OLE-DB Driver direct connection

Picture 2. Indirect connection to database through ODBC driver

2. Setup Database Connection Settings

2.1 Microsoft Access

1. Select Microsoft Jet OLE DB Provider On Data Link Properties.

2. Set the directory & filename of the microsoft access database. If the database file(*.mdb) located on the remote computer, make sure the folder is shared.

2.2Oracle

1. Select "Microsoft OLE DB Driver Provider for Oracle" on Data Link Properties.

2. Set the database connection property.

2.3 SQL Server

1. Select "Microsoft OLE DB Driver Provider for SQL Server" on Data Link Properties.

2. Set the database connection property.

2.4 MySQL

Setting Data Source (ODBC)

1. Since the OLE DB Provider for MySQL is not available, the ODBC connection should be created. Install the MySQL ODBC Driver, the installer could be downloaded from MySQL website.

2. Open Data Source (ODBC) on Windows >>Control Panel >> Administrative Tools

3. Add new System DSN using MySQL ODBC Driver

4. Set the database connection property.

Database Settings on SMSgee Software

1. Select "Microsoft OLE DB Driver Provider for ODBC Drivers" on Data Link Properties.

2. Set the database connection property.