Setup/Connection Issues

You are experiencing a setup/connection issue if you are encountering an error or hang while you are trying to make a database connection with the ODBC driver or are trying to configure the ODBC driver.

Some common errors that are returned by the ODBC driver if you are experiencing a setup/connection issue include:

■	Specified driver could not be loaded.

■	Data source name not found and no default driver specified.

■	Cannot open shared library: libodbc.sl.

■	ORA-12203: Unable to connect to destination.

■	ORA-01017: invalid username/password; logon denied.

Troubleshooting the Issue

Some common reasons that setup/connection issues occur are:

■	The library path environment variable is not set correctly.

NOTE: The 32-bit and 64-bit Salesforce driver require that you set the library path environment for your operating system to the directory containing your 32-bit JVM’s libjvm.so [sl | a] file, and that directory’s parent directory before using the driver.

HP-UX ONLY:

●	When setting the library path environment variable on HP-UX operating systems, specifying the parent directory is not required.

●	You also must set the LD_PRELOAD environment variable to the fully qualified path of the libjvm.so[sl].

The library path environment variable is:

32-bit Drivers

●	PATH on Windows

●	LD_LIBRARY_PATH on Solaris, Linux and HP-UX Itanium

●	SHLIB_PATH on HP-UX PA_RISC

●	LIBPATH on AIX

64-bit Drivers

●	PATH on Windows

●	LD_LIBRARY_PATH on Solaris, HP-UX, and Linux

●	LIBPATH on AIX

■	The database and/or listener are not started.

■	The ODBCINI environment variable is not set correctly for the ODBC drivers on UNIX and Linux.

■

The ODBC driver’s connection attributes are not set correctly in the system information file on UNIX and Linux (refer to “Data Source Configuration” in Chapter 4 of the DataDirect Connect Series for ODBC User’s Guide). For example, the host name or port number are not correctly configured. Refer to individual driver chapters in the DataDirect Connect Series for ODBC User’s Guide for a list of connection string attributes that are required for each driver to connect properly to the underlying database.

For UNIX and Linux users: Refer to Chapter 4 “Configuring the Product on UNIX/Linux” in the DataDirect Connect Series for ODBC User’s Guide for more information. See also “The Test Loading Tool” for information about a helpful diagnostic tool.