05-12-2015 05:46 PM
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).
05-12-2015 10:51 PM
So you have worked through the SAS install instructions?
05-13-2015 07:15 AM
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.