SAS 9.4 Connect Sybase from Windows 10 fails with message "Sybase SASSYB appendage cannot be loaded"

[J_Muth]

Dear all!

Since all of our PCs have been updated to Windows 10, also an old legacy system has been changed. The version of SAS on that computer (formerly 9.2) has also been updated to 9.4.

But the old scripts do not work any more since the connection to sybase does not work. The libname or proc sql/connect statements give: ERROR: The SAS/ACCESS Interface to Sybase SASSYB appendage cannot be loaded.

proc sql;
connect to sybase(server=<ourservername> database=<ourdb> user=<me> password=<mypwd>);
some sql...
quit;

I also installed SAS 9.2 on the same PC and the connection is working from there!

I added the -SET sassyb sywx6150 to asv9.cfg as described in the Config Guide http://support.sas.com/documentation/installcenter/en/ikfdtnwx6cg/66385/PDF/default/config.pdf

Any ideas what I can check or how I can debug the problem?

Windows 10, Version 1809 (OS Build 17763.740

Sybase PC Client Components 15.0.3 ESD 1

Information from SAS 9.4

Proc setinit:

...

Operating System: WX64_WKS.
Product expiration dates:
---Base SAS Software
31JAN2020

...
---SAS/ACCESS Interface to Sybase
31JAN2020

Proc PRODUCT_STATUS:
For Base SAS Software ...
Custom version information: 9.4
Image version information: 9.04.01M0P061913
...
For SAS/ACCESS Interface to Sybase ...
Custom version information: 9.4

Thank you for help or hints!

[SASKiwi · Accepted solution]

Is your SAS 9.2 32-bit and your SAS 9.4 64-bit by any chance? That might explain the error you have. The bitness of SAS must match the bitness of the Sybase client.

[J_Muth]

Yes, it is.

But the Sybase Client is also installed in a 32- and 64-bit version. At least there are two versions of all the DLLs in \sybase\OCS-15_0\dll.

(xxxx.dll and xxxx64.dll)

And the 64bit version seems to be working because isql -version gives me

Sybase CTISQL Utility/15.0/P-EBF16315 ESD #16/X64/BUILD1500-112/OPT/Sun Oct 12 20:05:46 2008

that I interpret as being the 64bit version.

[J_Muth]

And thank you for the input.

When I uninstall the 32-bit version of Sybase driver, could that give me more information?

I don't want to mess up the things unnecessarily that currently work by changing the things that were fixed already.

[J_Muth]

I uninstalled all sybase drivers and installed 15.7.

Now SAS 9.2 32 and 9.4 64 can connect.

Thank you

[SASKiwi]

@J_Muth  - Glad to hear it is now working.