Connection to MySQL database fails: Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver)

Follow

Comments

3 comments

  • Avatar
    Christopher Danks

    step 4 is incorrect as adding > after bin64 would cause an error.  replace > with \ and remove the space.

  • Avatar
    Ivan Postnikov

    @Christopher Danks
    Hello!
    Thank you for notice.
    The article was updated.

  • Avatar
    esfahanhost

    Hi

    i add only (  Unicode Driver ) in connection string and problem resolved

    Change this :

    Conn.Open "DRIVER={MySQL ODBC 5.3 };SERVER=localhost; DATABASE=psa; UID=admin;PASSWORD=mypassword;Port=8306; OPTION=3"

    To :

    Conn.Open "DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=localhost; DATABASE=psa; UID=admin;PASSWORD=mypassword;Port=8306; OPTION=3"

     

    Best Regards

    Masoud Saeidi

    http://www.esfahanhost.com

Please sign in to leave a comment.

Have more questions? Submit a request