topic Re: MySQL connecting issue in SAS Programming

MySQL connecting issue

BrahmanandaRao — Tue, 18 Aug 2020 05:41:26 GMT

Hi guys

Good Morning

please fix following error

/*Here I want to connect MySQL database in sas9.4 */

proc sql;
connect to mysql as dbcon
(user=root password=root server=mysql
database=mysqldb port=9876);
quit;

/*This example connects to MySQL and sends it two EXECUTE statements to process:*/

proc sql;
   connect to mysql (user=myusr1 password=mypwd1 server=mysrv1
        database=mysqldb port=9876);
   execute (create table whotookorders as
      select ordernum, takenby,
             firstname, lastname, phone
         from orders, employees
         where orders.takenby=employees.empid)
      by mysql;
   execute (grant select on whotookorders
            to myusr1) by mysql;
   disconnect from mysql;
quit;

Re: MySQL connecting issue

andreas_lds — Tue, 18 Aug 2020 06:07:26 GMT

Looks as if the mysql engine is not installed. proc product_status show the installed modules, so execute:

proc product_status;run;

and have a look at the log.

In further posts ALWAYS post the log as text using the "Insert Code"

Re: MySQL connecting issue

s_lassen — Tue, 18 Aug 2020 06:24:38 GMT

It seems that you do not have SAS/Access for MySQL installed. Apart from installing it, there is also the possibility of setting up an ODBC connection to the database and use that - if you have SAS/Access for ODBC, of course. If you do have it, the ODBC option may save you some license money.