###### Tickets

1 comment

• Philip Logie

Hi Stephen, thanks for this handy shortcut. It's worth remembering though, that this location will be overwritten if WPS is subsequently reinstalled or upgraded, so the step to copy the .dll file would have to be repeated in these cases.

For that reason, the standard method is to ensure that the environment variable PATH includes the location of the file, as described in this article:

https://support.worldprogramming.com/hc/en-gb/articles/360003137477-Connecting-to-a-MySQL-database-from-WPS-Analytics-on-Windows

Setting the PATH environment variable can also be performed programmatically by using the %sysget function - for example on Windows:

assuming that C:\Program Files\mysql\6.0\win64 is the location of the .dll.

Philip Logie
Customer Support | WPS Analytics