topic Re: Installing SAS ODBC Driver on Windows 10 in Administration and Deployment

Installing SAS ODBC Driver on Windows 10

Martyn — Sun, 06 Mar 2016 10:08:51 GMT

Having been forced to upgrade my PC and go to Windows 10 Pro, I downloaded and installed SAS 9.4 TS0M3.

Being a prolific user of the SAS ODBC driver to get SAS data into Excel, I looked for instructions for W10 on how to do it.

I couldn't find any.

So I reapplied the actions that I had done on W7 - added the SAS ODBC driver as a User Data Source, and edited the SERVICES file to add the SAS ODBC service.

However, I get a "driver's sqlsetconnectattr failed" message when I try chose the SAS ODBC data source in Excel.

Anyone got this working on Windows 10?

Martyn

Re: Installing SAS ODBC Driver on Windows 10

Norman21 — Sun, 06 Mar 2016 10:43:26 GMT

This thread might help:

https://communities.sas.com/t5/Administration-and-Deployment/SAS-on-Windows-10/td-p/198940

Norman.

Re: Installing SAS ODBC Driver on Windows 10

Martyn — Sun, 06 Mar 2016 10:59:49 GMT

Thanks, Norman. Unfortunately, nothing on the ODBC driver there...

Martyn

Re: Installing SAS ODBC Driver on Windows 10

LinusH — Sun, 06 Mar 2016 21:28:49 GMT

Moved to admin forum, since this seem to have to do about installation and configuration, and not SAS programming specifically.

Re: Installing SAS ODBC Driver on Windows 10

JuanS_OCS — Sun, 06 Mar 2016 22:14:49 GMT

Hi,

Just a wild guess. There was a popular similar issue, some time ago, related to some windows registries not properly updated/handled.

I wonder if this might help:

http://support.sas.com/kb/10/022.html

Re: Installing SAS ODBC Driver on Windows 10

Martyn — Mon, 07 Mar 2016 16:16:45 GMT

In the end, a simple solution that I would have found sooner if I'd put my glasses on.

I had mistyped the server name in the ODBC screen. Instead of 2 underscores before the port name, I had 3. As soon as I changed it, everything seems to work.

Sorry to have wasted peoples time.

Martyn

Re: Installing SAS ODBC Driver on Windows 10

JuanS_OCS — Mon, 07 Mar 2016 16:43:12 GMT

Hi, thanks for the update, and happy to read that you managed to solve it! 🙂

Re: Installing SAS ODBC Driver on Windows 10

LinusH — Mon, 07 Mar 2016 16:46:13 GMT

Multiple underscores, dangerous as multiple spaces...