cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jakewendt
‎10-13-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: The MYSQL engine cannot be found

by Calcite | Level 5 in SAS Programming
‎10-13-2015 03:52 PM
‎10-13-2015 03:52 PM
This seems to be the case.  Thank you. ... View more

Re: The MYSQL engine cannot be found

by Calcite | Level 5 in SAS Programming
‎10-13-2015 03:52 PM
‎10-13-2015 03:52 PM
Original site validation data Current version: 9.04.01M3P062415 Site name: 'UNIVERSITY EDITION 2.2 9.4M3 WITH ETS FOR PLAYER'. Site number: 70186327. CPU A: Model name='' model number='' serial='+2'. Expiration: 15JUN2016. Grace Period: 0 days (ending 15JUN2016). Warning Period: 46 days (ending 31JUL2016). System birthday: 02JUL2015. Operating System: LIN X64 . Product expiration dates: ---Base SAS Software 15JUN2016 (CPU A) ---SAS/STAT 15JUN2016 (CPU A) ---SAS/ETS 15JUN2016 (CPU A) ---SAS/IML 15JUN2016 (CPU A) ---SAS/ACCESS Interface to PC Files 15JUN2016 (CPU A) ---SAS/IML Studio 15JUN2016 (CPU A) ---SAS Workspace Server for Local Access 15JUN2016 (CPU A) ---SAS Workspace Server for Enterprise Access 15JUN2016 (CPU A) ---High Performance Suite   I presume then that "SAS/ACCESS Interface to PC Files" does not include access to a MySQL database.  Bummer.   Thank you. ... View more

The MYSQL engine cannot be found

by Calcite | Level 5 in SAS Programming
‎10-13-2015 12:36 PM
‎10-13-2015 12:36 PM
  I am very new to SAS, but otherwise very experienced in computing.  I'm using a 5 year old MacBook Pro running El Capitan.  I installed Oracle VirtualBox and started the free SAS University Edition on it.  I have mariadb (the now open source version of MySQL) installed locally via MacPorts.  I can use mysql from the command line without issue.  I am trying to simply connect SAS to a database, any database at this point, just to prove that it can be done.   I have tried many versions of the following one-liner with and without some of the options   libname mysqllib mysql user=root password="" database=mytestdb server=localhost;   from the example in   https://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002913931.htm   but I always get the same error in the log.   ERROR: The MYSQL engine cannot be found. ERROR: Error in the LIBNAME statement.   I've searched online and can't find a solution.   Do I need to set some environment variable? Does the free version not include something that I need here? Is SAS not compatible with the MariaDB version of MySQL? Do I need to install something else? Do I need to tell SAS where it can find the MYSQL engine? Is this a VirtualBox issue?   Thank you in advance. Jake ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-13-2015 04:27 PM
Quick links