topic Re: using odbc to access data in spds server in Administration and Deployment

using odbc to access data in spds server

manas00 — Tue, 12 May 2015 21:46:04 GMT

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

Re: using odbc to access data in spds server

SASKiwi — Wed, 13 May 2015 02:51:23 GMT

So you have worked through the SAS install instructions?

http://support.sas.com/documentation/cdl/en/odbcdref/64777/HTML/default/viewer.htm#n13ny8xldqztnun11du05jc373q9.htm

Re: using odbc to access data in spds server

manas00 — Wed, 13 May 2015 11:15:51 GMT

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.

Re: using odbc to access data in spds server

SASKiwi — Sat, 23 May 2015 03:25:26 GMT

I'd suggest to start a track with Tech Support on this if you haven't already done so.

Re: using odbc to access data in spds server

MLikelihood — Tue, 13 Oct 2015 15:43:39 GMT

I am also experiencing this error with no resolution.

Re: using odbc to access data in spds server

SASKiwi — Tue, 13 Oct 2015 19:11:28 GMT

This type of problem is best dealt with by SAS Tech Support.