Architecting, installing and maintaining your SAS environment

using odbc to access data in spds server

Reply
New Contributor
Posts: 2

using odbc to access data in spds server

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

Super User
Posts: 3,105

Re: using odbc to access data in spds server

New Contributor
Posts: 2

Re: using odbc to access data in spds server

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.

Super User
Posts: 3,105

Re: using odbc to access data in spds server

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

User
Posts: 1

Re: using odbc to access data in spds server

I am also experiencing this error with no resolution. 

Super User
Posts: 3,105

Re: using odbc to access data in spds server

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

Ask a Question
Discussion stats
  • 5 replies
  • 913 views
  • 0 likes
  • 3 in conversation