DATA Step, Macro, Functions and more

SAS/ACCESS to MySQL via SSL

Reply
Regular Learner
Posts: 1

SAS/ACCESS to MySQL via SSL

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;

 

SAS Employee
Posts: 203

Re: SAS/ACCESS to MySQL via SSL

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.

 

make_a_feature_request.jpg

 

 If you need any assistance, holler.

 

Best wishes,

Jeff

Ask a Question
Discussion stats
  • 1 reply
  • 208 views
  • 0 likes
  • 2 in conversation