MySQL connecting issue

[BrahmanandaRao]

Hi guys

Good Morning 

please fix following error 

Anandkvn_0-1597729264704.png

/*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;

[andreas_lds]

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"

[s_lassen]

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.