Devart Forums

I have a working Delphi application that connects to a remote mySQL database on my hosted web site. I say "working" because it was working (and had been working for years) as of last Friday.

Over the weekend my web hosting company did some updates on mySQL. Since then, I am unable to connect. Web hosting company says the problem is in my application.

I'm not sure what information would be helpful.

In my MyConnection, I have the following properties set:

Database
Password
Server
Username

I have verified that all these are correct by entering them on a "connection test" page provided by my web host.

What I do not understand is that when I run my application and attempt to connect through the MyConnection, I am getting the following error:

Access denied for user ''@'adsl-75-24-141-246.dsl.chcgil.sbcglobal.net' (using password: NO)

My local internet service is provided through sbcglobal DSL. It appears as if my router/modem is passing different login information to my web host?

In working with my hosting company, I have added the following as "remote database access hosts"

75.24.141.246
75.24.141.246.dsl.chcgil.sbcglobal.net

Have been struggling with this for 2 days and am not sure how to proceed... any help greatly appreciated.

Many views, no responses. Am I explaining my problem clearly? If not, I will be happy to try and clarify.

As a follow up, in discussing this problem with my web hosting company, they are insisting that the username and password that is being passed is not what I have specified in my MyConnection. This would appear to be confirmed by the text of the error message I'm getting.

The web hosting company is assuming I'm running a script and they're asking for a copy to help diagnose. I've explained that it's a compiled Windows executable.

Is there any way to troubleshoot exactly what my application is sending as login information?

Hello,

Try reseting your password on the server. If it doesn't help, then upgrade MyDAC to version 6.00.0.1 and try connecting to web host with it.

AndreyZ wrote:Try reseting your password on the server. If it doesn't help, then upgrade MyDAC to version 6.00.0.1 and try connecting to web host with it.

I upgraded MyDAC as suggested, and that fixed the problem.

Thank you!

It is good to see that this problem has been solved.