The following code is used in PowerBuilder 8.01 to set a pointer to the
Sybase OpenClient software and define the SQLCA object.

type prototypes
FUNCTION boolean SetEnvironmentVariableA ( string szName, string
szValue ) LIBRARY "kernel32.dll"
end prototypes

SetEnvironmentVariableA("SYBASE", "R:\Sybase")

SQLCA.DBMS = "SYC Adaptive Server Enterprise"
SQLCA.Database = s_dbname
SQLCA.LogId = s_userid
SQLCA.LogPass = s_password
SQLCA.ServerName = s_server
SQLCA.AutoCommit = TRUE
SQLCA.DBParm = "CommitOnDisconnect='No',Release = '12',Lock = '3',
AppName = 'MY Application', PWDialog =
1,PBCatalogOwner='dbo',ConnectString='UID="+s_user id+",PWD="+s_password+"'"

Connections work fine in PowerBuilder 8, but PowerBuilder 10.2.0
returns an error message stating that the application failed to
initialize the client.

Any hints?
TIA,
Chris Hatfield
Falls Church, Virginia
US of A

Hello,

What version of Open Client are you using?
Type the following command to find the version:
c:\ find /I "Intel" c:\sybase\ocs-12_5\dll\libct.dll
or
find /I "Intel" c:\sybase\dll\libct.dll

Does that version match what you have in In the database
profile setup (SYC) "Release dropdown"?

Are the Open Client DLL and BIN subdirectories in the PATH environment
variable?