Accessing MySQL database with WPS under Windows

Comments

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
    0
    Comment actions Permalink

Please sign in to leave a comment.