Hi,
I have installed SAS ODBC drivers from the sas website (recommended ones) and want to connect to SPDS server. I have qlikview but it fails. I tried to follow the instructions in odbc sys guide but it says unable to load library spds.dll failed with return code 126. Not sure why the dsn is not able to get any data from spds (tested in microsoft access too). my system is 64-bit, odbc-9.42/9.3(same error).
-Thanks
So you have worked through the SAS install instructions?
yes I have tried everything on the page,but still the error is :
Load library c:\programfiles\sashome2\sasdriversforodbc\9.42\spds.dll() failed with return code 126
I installed 9.42 as well as 9.3 odbc drivers and have the spds.dll file from the server pasted on the above location,but nothing works.
I'd suggest to start a track with Tech Support on this if you haven't already done so.
I am also experiencing this error with no resolution.
This type of problem is best dealt with by SAS Tech Support.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.