topic Re: SAS ODBC Connection in QlikView

SAS ODBC Connection

Wed, 29 Jul 2015 10:17:55 GMT

Hi,

I'm trying to connect to a SAS dataset. I've been able to install the SAS ODBC driver and can see it as a connection option in QlikView but am getting the below error.

Connection Test Failed

SQL##f - SqlState: IM003, ErrorCode: 160, ErrorMsg:
Specified driver could not be loaded due to system error 126: The
specified module could not be found. (SAS, C:\Program
Files\SASHome2\SASDriversforODBC\9.43\sasdrv32.dll).

I checked for the file and it appears to be at that location.

Any thoughts on where I'm going wrong would be much appreciated.

Rgds

Jenny

Re: SAS ODBC Connection

Thu, 10 Dec 2015 19:43:02 GMT

Hi Jenny,

I am coming across the exact same problem while using the 64-bit version of SAS ODBC driver and connecting to 64 bit Qlikview. Did you find a resolution to this issue ? Please let me know.

Thanks,

Puneet.

Re: SAS ODBC Connection

Wed, 03 Feb 2016 12:00:38 GMT

Hi Jenny, Punnet,

Have you resolved that issue? If yes can you please share it?

I am trying to connect to a SAS and I am facing that same error.

Best regards,

Jorge Brugos

Re: SAS ODBC Connection

Wed, 03 Feb 2016 18:14:28 GMT

Hi all,

My Problem seems to be that the ODBC driver is not compatible with MS 2012 R2, since we are able to run it successfully on Windows 8.

Kind regards,

Jorge Brugos

Re: SAS ODBC Connection

correjy — Mon, 18 Apr 2016 12:50:49 GMT

Hi all,

The latest version of SAS 9.4 ODBC do not run with Qlikview server x64 2012 R2.

You have to download the following version here : http://support.sas.com/downloads/package.htm?pid=1276

Uninstall the current version before install the new one the reboot server.

Regards

Jean-Yves Corre

Re: SAS ODBC Connection

Anonymous — Tue, 02 Aug 2016 23:01:47 GMT

hello, with odbc driver gives many problems try the oledb you have to do is:
Sas install on your local machine
Install the driver oledb
Server name and port to which you are connecting SAS
Names of tables or libraries where you will extract the information
Since you have everything you need to request access to the tables that you need because they have an owner.
And then you can make the connection as you will ask these data.
I show the steps of the connection , I hope they serve

Select the connector SAS IOM Data Provider 9.42

Then we click Next and proceed to the connecting flange in which we enter the following data:

We spent the next Advanced tab , we disable the default use palomita and then entered the following data is the server name and port

We click on Test Connection and appears to us that the connection was successful :

We click on Select and we appear the tables you have access :