Architecting, installing and maintaining your SAS environment

SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 75
Accepted Solution

SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

Has anyone experience loading data from MS SQL 2016 server from SAS 9.4 M2? On the SAS support pages it says that we need to run at least SAS 9.4 M3! But how can we do that easy? I presume that the whole environment should be upgraded then?

 

Thanks in  advance.


Accepted Solutions
Solution
‎04-11-2017 04:55 PM
Super User
Posts: 3,250

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

[ Edited ]

If you are running SAS 9.4M2 on Windows then SAS Support gave you the correct answer. SAS only started supporting the Windows platform for SAS/ACCESS to SQL Server from 9.4M3. Under Unix, earlier SAS versions of SAS/ACCESS to SQL Server are available.

 

If you want to stay with SAS 9.4M2 (upgrading can be costly and time consuming) and you are running on Windows then you could use SAS/ACCESS to ODBC with SQL Server instead. This is what we use and performance is excellent.

View solution in original post


All Replies
SAS Super FREQ
Posts: 299

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

Hi,

 

yes, M3 is needed to support MS SQL 2016 Server.

 

For information on upgrading to a new maintenance release, please see

http://support.sas.com/software/maintenance/index.html

 

Hope that helps

Thanks

Anja

Frequent Contributor
Posts: 75

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

so we need to upgrade the whole installation and can not add one component whivh os newer?

Super User
Posts: 3,250

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

Correct. All products in your SAS installation need to be on the same maintenance release to ensure compatibility.

Occasional Contributor
Posts: 7

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

Hi, we access our SQL Server 2016 database with SAS 9.3 (TS1M2) on AIX 7.1.

 

What situation requires you to have SAS 9.4?  Where did you read this in the documentation?

 

Paul

Frequent Contributor
Posts: 75

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

It sounds interesting. What interface do you use - is it SAS/ACCESS interface to Microsoft SQLserver?

 

We run sas 9.4M2 and sas support told me that we needed to upgrade to at least 9.4M3 and gave me this link:

http://www.google.dk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjB5rXwoY3TAh...

 

Solution
‎04-11-2017 04:55 PM
Super User
Posts: 3,250

Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server

[ Edited ]

If you are running SAS 9.4M2 on Windows then SAS Support gave you the correct answer. SAS only started supporting the Windows platform for SAS/ACCESS to SQL Server from 9.4M3. Under Unix, earlier SAS versions of SAS/ACCESS to SQL Server are available.

 

If you want to stay with SAS 9.4M2 (upgrading can be costly and time consuming) and you are running on Windows then you could use SAS/ACCESS to ODBC with SQL Server instead. This is what we use and performance is excellent.

☑ This topic is solved.

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

Discussion stats
  • 6 replies
  • 478 views
  • 0 likes
  • 4 in conversation