If you have problems connecting to the data source from the database client software, investigate the following possible causes:
Is the database client software installed? Are all database client components required for the ODBC connections installed?
To enable ODBC connections, some database client software may require additional software components beyond the basic server software. The database client software usually is required on the computer that uses ODBC to connect to the data source server and may also be required on the data source server computer.
Is the database client software compatible with the data source?
Earlier or later versions of the database client software may not work with the data source version that you are running. See your data source documentation.
Do the database client software utilities, such as the command-line SQL interface, start? Do they start when you are logged on as the user who runs Integration Server?
When you run the database client software, the user account must have the appropriate file access permissions and must have set the path and other environment variables. Verify that the user who runs Integration Server (typically, hyperion) is configured to run the database client software.
On UNIX systems, a script file is usually provided by the data source vendor to set the required environment variables and should be included in the main user login script. If you include one of these files in the main login script, make sure that you specify a complete directory path and that you follow the syntax for executing a script file within a script.
Are the data source server names, database names, user names, and passwords specified correctly?
Make sure you are using the correct names, including the exact spelling, uppercase or lowercase letters, and any required data source-specific identification syntax. See Correcting Data Source Problems.
Is the database client software configured correctly?
File access permissions, path, and other environment variables must be set for the user who runs the database client software. Additional configuration steps also may be required for specific database clients.
See the installation documentation for the database client software.
IBM DB2: You may be required to bind the database client software utilities to the IBM DB2 databases. See the IBM DB2 installation documentation.
Oracle: The database name for Oracle databases can be specified in a tnsnames.ora file, which must be configured by the database administrator. See the Oracle installation documentation.
In the sqlhosts file, you must specify a TCP protocol for your operating system as follows: