Architecting, installing and maintaining your SAS environment

Installing SAS ODBC Driver on Windows 10

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Installing SAS ODBC Driver on Windows 10

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


Accepted Solutions
Solution
‎03-07-2016 11:17 AM
New Contributor
Posts: 3

Re: Installing SAS ODBC Driver on Windows 10

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

View solution in original post


All Replies
Frequent Contributor
Posts: 95

Re: Installing SAS ODBC Driver on Windows 10

This thread might help:

 

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

 

Norman.

Norman.
SAS 9.4 (TS1M4) X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

New Contributor
Posts: 3

Re: Installing SAS ODBC Driver on Windows 10

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

 

Martyn

Super User
Posts: 5,433

Re: Installing SAS ODBC Driver on Windows 10

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

Data never sleeps
Trusted Advisor
Posts: 1,326

Re: Installing SAS ODBC Driver on Windows 10

[ Edited ]

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

 

Solution
‎03-07-2016 11:17 AM
New Contributor
Posts: 3

Re: Installing SAS ODBC Driver on Windows 10

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

Trusted Advisor
Posts: 1,326

Re: Installing SAS ODBC Driver on Windows 10

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

Super User
Posts: 5,433

Re: Installing SAS ODBC Driver on Windows 10

Multiple underscores, dangerous as multiple spaces...
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 1090 views
  • 0 likes
  • 4 in conversation