PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WEBDEV 2024 → HOpenConnection() not working with PHP/MySQL remote database
HOpenConnection() not working with PHP/MySQL remote database
Started by Ramon, Sep., 07 2013 7:29 PM - No answer
Posted on September, 07 2013 - 7:29 PM
I did create a MYSQL/PHP remote database.
I am able to connect to this database through WebDev WDMap tool.
However by programming I can't connect to this database.
I am receiving the following message:

"Error Code 73002
Error in Native access
The connection to the ,<my_database> database on <ip_address> failed.
Message returned by the database: The server requested authentication method unknown to the client"

In am using these parameters (same parameters that connect OK with WDMap tool)
gctConnectionToDatabase..Server = "IP_Address"
gctConnectionToDatabase..Database = "My_Database_Name"
gctConnectionToDatabase..User = "My_Username"
gctConnectionToDatabase..Password = "My_Password"
gctConnectionToDatabase..Provider = hNativeAccessMySQL


The HOpenConnection(gctConnectionToDatabase) function return false

Thanks in advance for your suggestion,