topic Re: SAS/ACCESS and MySQL error in Administration and Deployment

SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 15:38:26 GMT

I have installed MySQL on my computer and still seem to be getting this error:

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.

I also ran this code (proc setinit;run;) to make sure SAS/Access Interface to MySQL was on there.

Any help is much appreciated, thank you!

Re: SAS/ACCESS and MySQL error

Reeza — Mon, 23 Jul 2018 15:45:07 GMT

Post the code and full log.

Re: SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 15:49:55 GMT

227 libname mysql mysql USER='X' PASSWORD=XXXXXXXXXX DATABASE='X' SERVER='XXX.XXXX.com' PORT=X;

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.

The above code should be correct because it works for others that also have mySQL installed, but unfortunately is not working for mine

Re: SAS/ACCESS and MySQL error

Reeza — Mon, 23 Jul 2018 15:53:34 GMT

So no mySQL connection works for you? Run the following and see what's licensed versus what's installed.

*show licensed;
proc setinit;run;

*show installed;
proc product_status;run;

If proc product_status does not show the mySQL component it means it wasn't installed.

Re: SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 15:59:26 GMT

It looks like it was installed 😕

228 proc product_status;run;

For Base SAS Software ...
   Custom version information: 9.4_M4
   Image version information: 9.04.01M4P110916
For SAS/STAT ...
   Custom version information: 14.2
For SAS/GRAPH ...
   Custom version information: 9.4_M4
For High Performance Suite ...
   Custom version information: 2.2_M5
For SAS/ACCESS Interface to Oracle ...
   Custom version information: 9.41
For SAS/ACCESS Interface to PC Files ...
   Custom version information: 9.4_M4
For SAS/ACCESS Interface to MySQL ...
   Custom version information: 9.4_M4
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
      real time           0.09 seconds
      cpu time            0.01 seconds

Re: SAS/ACCESS and MySQL error

erjatin — Mon, 23 Jul 2018 15:59:42 GMT

It seems SAS access interface is unable to load drivers.

Are you able to access database outside SAS? if yes then please ensure you
have right entries in sasenv_local file.

Please refer to SAS data management guide chapters for making appropriate
entries.

Also please check if your installation directory has specific Ms access
client for SQL server. Use this driver preferably.

Let me know if you need specific path details.

Jatin

Re: SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 16:03:38 GMT

Hi Jatin,

I may need specific path details, I am still pretty new to SAS so I'm not sure how I would check that I have the right entries in the sasenv_local file and how to check the installation directory. Is that all in the SAS data management guide?

Thank you!

Re: SAS/ACCESS and MySQL error

erjatin — Mon, 23 Jul 2018 16:08:42 GMT

I am not able to recall exact folder name as of now but try to search
accessclient directory.

It should have sample in file...use that to make dns entry.

I will try to search useful documents.

Re: SAS/ACCESS and MySQL error

Reeza — Mon, 23 Jul 2018 16:12:29 GMT

Ask a colleague to try with their credentials on your machine.

Re: SAS/ACCESS and MySQL error

erjatin — Mon, 23 Jul 2018 16:16:42 GMT

Ok will try to search some information and share by tomorrow, I faced
similar issue sometime ago.

Re: SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 16:18:46 GMT

I can't seem to find a file that is close to accessclient in the directory. I would looking in the SASHome folder, correct?

Thank you again for all your help! I will try and keep working on it until tomorrow.

Re: SAS/ACCESS and MySQL error

erjatin — Mon, 23 Jul 2018 16:20:42 GMT

https://communities.sas.com/t5/SAS-Communities-Library/How-to-configure-SAS-ACCESS-Interface-to-ODBC-on-UNIX-Platforms/ta-p/231900

This should be helpful to start with.

Re: SAS/ACCESS and MySQL error

kmardinian — Mon, 23 Jul 2018 17:20:35 GMT

I finally figured it out. For some reason, MySQL was not in my path in my environmental variables, so my system was not recognizing it.

Thank you for you all your help!

Re: SAS/ACCESS and MySQL error

Woody2lax — Fri, 26 Jul 2019 15:43:19 GMT

I'm encountering the same issue. How did you add MySQL to your path?

Re: SAS/ACCESS and MySQL error

kmardinian — Fri, 26 Jul 2019 15:53:19 GMT

I compared my environment variables to another programmer on my team and manually added them for my SQl.

If SAS still cannot gain access to mysql, check to ensure environmental variables for mysql have the correct path.

Start-Control Panel-System-Advanced System Settings-Environment Variables-Path
Check that all mysql applications are in the Path (bottom of image)
If not in path, enter them manually

Hope this helps!

Re: SAS/ACCESS and MySQL error

Woody2lax — Fri, 26 Jul 2019 16:11:08 GMT

Success!!! Thank you.

Re: SAS/ACCESS and MySQL error

Mushtaq — Sat, 18 Jul 2020 06:14:45 GMT

Can you please provide more detail about how do you provide Environment Variables mysql to solve the problem. I using SAS eg to connect a maridb server using exactly same query like you and getting :

The libmysqlclient code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
options set=SASMYL MYWIN417;
libname mylib mysql server="xxxxxx" database=mysql user=xxx password=xxxxx port=9876;

I'll apriciate

Thanks

Mike

Re: SAS/ACCESS and MySQL error

Reeza — Sat, 18 Jul 2020 14:31:52 GMT

Do you mean the schema or some other parameter? I'm not familiar with MySQL.
https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n1lyg1d0crcejin1v7zaeteeniuu.htm&docsetVersion=9.4&locale=en