Previous Topic

Next Topic

Book Contents

Book Index

Configuring a Database Connection

In This Chapter

Connecting to DB2

Connecting to Informix

Connecting to MS Access

Connecting to MS SQL Server

Connecting to MySQL

Connecting to Oracle

Connecting to Sybase

Connecting to HP SQL/MX

Connecting to Excel

Connecting to Text and CSV Files

Connecting to SQLite

Before you can sign-on to a database, you must configure an ODBC Datasource for that database.

The way you configure an ODBC Datasource is different for each type of database. In the following sections I describe how this is done for each database type. This section gives general comments about how this is done.

As a general rule, the following steps need to be done in order to access a database:

Install Database Client Software and/or ODBC Driver.

In most cases, before you can connect to your database you will need both:

In many cases, the client and ODBC Driver are packaged together (eg. when you install the client, you will also get the ODBC driver).

Client software is not required for MS Access, MS SQL Server, text, Excel and dBase databases, as drivers for these come as a part of the standard Windows install.

Configure the Client

You will need to configure the database client in order for it to connect to your database. For some databases, configuring the database client is done as part of the ODBC Datasource Setup, for other databases this is a separate step.

In order for your client to be able to connect with the server, it will need to know the following information:

We cannot help you with this information - you will need to see your DBA for this information.

Administering ODBC Datasources

This can be done in two ways.

Set up an new Datasource

To create a new ODBC Datasource:

Many ODBC Drivers have a button Test Connection. It is a good idea to use this to see whether the connection to the database has been configured correctly.