09-25-2015 12:37 PM
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?
libname test mysql user=testuser password=test database=test server='test.amazonaws.com' port=3306 BULKLOAD=YES;
09-25-2015 03:05 PM
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.