Datastage ODBC Connection Problems - Part 3

Datastage ODBC Problem : Checking symbolic links :DK®

If your ODBC connection does not work, check your symbolic links. Cannot connect to database using ODBC connection.This problem occurs when using ODBC connections in a UNIX environment.DK®

Identify the Issue :DK®

If you have moved shared libraries to a new directory or have installed a new ODBC driver manager, you might have broken symbolic links that the engine uses to access the shared libraries for the source database.

Solution Of the problem:DK®

To reset the symbolic links to a new directory, run this command at the UNIX prompt:

# $DSHOME/bin/dspackinst relink.uvlibs pathname

$DSHOME is the home directory of the server engine. pathname is the full path name of the directory that contains the shared libraries.

To reset links for a new ODBC driver manager:DK®

1. Install the ODBC driver manager according to the vendor's instructions.
2. Determine where the ODBC shared library libodbc.xx resides. For example, the library for the Intersolv driver is in $ODBCHOME/ dlls,
   and the library for the Visigenics driver is in $ODBCHOME/ libs.
3. Close all InfoSphere DataStage clients.
4. Run the relink.uvlibs command as described above.
5. Restart the InfoSphere DataStage clients.
   
   
   Other Related Topics :DK®
   Click here for Datastage ODBC Connection Problems - Part1DK®
   Click here for Datastage ODBC Connection Problems - Part2DK®