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;
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.
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.