SAS/ACCESS to MySQL via SSL

SAS_ANON — Fri, 25 Sep 2015 16:37:04 GMT

I am currently using Base SAS 9.3 & SAS/ACCESS to MySQL but I am having diffuclty establishing an SSL connection with a server using SAS/ACCESS. What is the format for making a SSL connection using SAS/ACCESS or do I have to use a different method?

Thanks.

libname test mysql user=testuser password=test database=test server='test.amazonaws.com' port=3306 BULKLOAD=YES;

Re: SAS/ACCESS to MySQL via SSL

JBailey — Fri, 15 Nov 2019 17:11:22 GMT

Wow, it looks like somebody pushed that button, and I did actual work, but not "real" work. Real work would be coding.

Hat tip @JYus for pointing out that SAS has implemented this.

https://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=n1rfxdp6mpk61rn148n17nvhvfix.htm&docsetVersion=9.4&locale=en

~~Hi,~~

~~Unfortunately, connecting to MySQL from SAS/ACCESS using SSL is not supported.~~

~~If you like, you can make a feature request via the following link. I know the feature has been requested, but it doesn't hurt to pile-on just a little.~~

~~Go to http://support.sas.com. And look at the bottom left of the page.~~

If you need any assistance, holler.

Best wishes,

Jeff

topic Re: SAS/ACCESS to MySQL via SSL in SAS Programming

SAS/ACCESS to MySQL via SSL

Re: SAS/ACCESS to MySQL via SSL