topic The MYSQL engine cannot be found in SAS Programming

The MYSQL engine cannot be found

jakewendt — Tue, 13 Oct 2015 16:36:52 GMT

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

Re: The MYSQL engine cannot be found

SASKiwi — Tue, 13 Oct 2015 18:37:37 GMT

I suspect that the SAS/ACCESS to MySQL product is not in SAS University Edition.

Run PROC SETINIT to confirm the products available:

proc setinit noalias;
run;

Re: The MYSQL engine cannot be found

LinusH — Tue, 13 Oct 2015 18:38:09 GMT

Generally, it might work with MariaDB, but SAS would probably not support this.

When it comes to the University Edition, I don't see MySQL in list of ACCESS engines included,

http://support.sas.com/software/products/university-edition/index.html

Re: The MYSQL engine cannot be found

jakewendt — Tue, 13 Oct 2015 19:52:07 GMT

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.

Re: The MYSQL engine cannot be found

jakewendt — Tue, 13 Oct 2015 19:52:56 GMT

This seems to be the case. Thank you.