Troubleshooting ODBC and Connections

In This Section:

Common Connection Problems

Database-Specific Problems

ODBC and Connection Problems

Isolating Connection Problems

Correcting Connection Problems

Using ODBC Tracing

Integration Services requires several layers of software components to connect to data sources and load data into Essbase databases. Each of the components must be configured properly to run and communicate with each other. Consequently, diagnosing and correcting connection problems in the system can be challenging.

This chapter assists you in isolating and correcting connection problems that can occur during the operation of Integration Services. The first topic of this chapter lists common causes for connection problems. The subsequent topics outline a strategy for isolating and correcting connection problems not addressed by the common problems list.

This chapter assumes that you know how to perform basic database administration tasks, such as using a database client utility program to connect to a database server, navigating directories using a command prompt, and editing configuration files.