topic Re: SAS/ACCESS Interface to Microsoft SQL Server - SAS 9.4 M2 to MS SQL 2016 server in Administration and Deployment

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

ANLYNG — Wed, 05 Apr 2017 17:02:30 GMT

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.

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

anja — Wed, 05 Apr 2017 17:33:26 GMT

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

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

ANLYNG — Wed, 05 Apr 2017 17:36:31 GMT

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

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

SASKiwi — Wed, 05 Apr 2017 20:08:51 GMT

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

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

PaulOK01 — Wed, 05 Apr 2017 22:41:18 GMT

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

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

ANLYNG — Thu, 06 Apr 2017 05:43:55 GMT

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=0ahUKEwjB5rXwoY3TAhWndpoKHTCSD3QQFgglMAA&url=http%3A%2F%2Fsupport.sas.com%2Fdocumentation%2Finstallcenter%2Fen%2Fikfdtnwx6sr%2F66390%2FPDF%2Fdefault%2Fsreq.pdf&usg=AFQjCNFPOQvXnbRf3dh-LLSkK6UjCiD4dg&sig2=u4lVe3oAlcrUEXTKOJctuQ

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

SASKiwi — Thu, 06 Apr 2017 20:03:31 GMT

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.