SAS/ACCESS and MySQL error

[kmardinian]

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!

[Reeza]

Post the code and full log.

[kmardinian]

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

[Reeza]

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. 

[kmardinian]

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

[erjatin]

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.

[erjatin]

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

[kmardinian]

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!

[erjatin]

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

[kmardinian]

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.

[erjatin]

https://communities.sas.com/t5/SAS-Communities-Library/How-to-configure-SAS-ACCESS-Interface-to-ODBC...

This should be helpful to start with.

[kmardinian · Accepted solution]

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!

[Woody2lax]

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

[kmardinian]

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.

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

Hope this helps!

[Woody2lax]

Success!!! Thank you.