Obviously the environment variables for Sybase access have not been set correctly. I don't know them all off the top of my head, I do recall that there's some variable like SYBASE_HOME (or similar), that the PATH variable must contain %SYBASE_HOME%\bin, and some more.
The best way to ensure that this works is to follow the setup instructions from Sybase and to make sure that all these environment variables are system-wide environment variables and not specific to the user ID running the Informatica service on the Windows server (the Windows service named "Informatica 10.2").
2 of 2 people found this helpful
In Windows , if you can , you can install Dependency Walker, a third party utility and open the pmsybs.dll in it .
It should ideally show which libraries are missing and you can inturn see where those libraries are and add the path to your PATH environment variable
Link to Dependency walker
Below documentation can also help in identifying which environment variables you need for Sybase
Please note any change to environment variables requires a restart of Informatica services to be effective.
In addition to the details shared by Nico and Santosh, you can share the list of environment variables set on the server here.
Just found the exact directories that must be included in the PATH environment variable. Usually these directories should be included in the PATH variable by the Sybase installer, but if - for example - someone just copied the directory containing the Sybase driver instead of installing it, then those changes to the environment variables need to be executed by the system administrator.
Please check whether the environment variables contain the following directories (this example assumes that the Sybase driver has been installled under Q:\Sybase and that the Sybase ASE 16.0 client has been installed):
Variable INCLUDE must be set to:
Variable LIB must be set to these directories:
Variable PATH must contain these directories:
Variable SAP_JRE7 must be set to:
Variable SAP_JRE7_32 must be set to:
Variable SAP_JRE7_64 must be set to:
Variable SYBASE must be set to:
Variable SYBASE_OCS must be set to:
Variable SYBROOT must be set to:
Also it's advisable to include the %INFA_HOME%\server\bin directory (for example, D:\INFA\10.4.1\server\bin if the software has been installed in D:\INFA\10.4.1 ) in the PATH variable.
Also, after the Sybase client has been installed, it must be made sure that these environment variables (resp. the extension to PATH) are set as system environment variables and not environment variables of the user ID which has installed the Sybase client.
Not to forget that after installation of the Sybase client it's advisable (at least in my experience) to reboot the server (no joke). Otherwise the changed environment may not be taken to use by the user ID running the Windows service for the Informatica software.