- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I uninstalled all sybase drivers and installed 15.7.
Now SAS 9.2 32 and 9.4 64 can connect.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@J_Muth - Glad to hear it is now working.