Odbc And Making A Connection

[a_edwall]

Hi,

Please help me if you can.

I program in Visual Basic and I need a simpler way to backup my MySQL database data than what SQLyog allows (the Scheduled Backup feature does not work and it doesn't tell me why – I have written a separate e-mail on that).

I have written a simple connection string in VB to connect with MySQL databases. The effort works fine on one web host that uses MySQL v4.0.24, but no matter what I do I cannot get the same script to connect on another website hosted by the same provider which uses MySQL v4.1.11. When I try to connect to the MySQL v4.1.11 database, I get the error, “Client does not support authentication protocol requested by server; consider upgrading MySQL client”. I have read the material at the MySQL website on this error message and tried all their suggestions – nothing works.

But SQLyog WORKS!!!!! It connects, even though the same script I am using with the same host (a-plus.net) works on only 1 database and not another.

My question is this – a favor actually. Can you give me an idea as to what you use in SQLyog to make the connection so I can incorporate that connection scheme into my program and be able to write my own custom backup routines? I would be very grateful if you can help me out, as a-plus.net just gives me the run-around saying, “Since phpMyAdmin works on both websites, everything must be okay.” They fail to consider my telling them that running the ODBC applet from within CONTROL PANEL connects fine to one website but not the other – which is my problem, of course!

If I can circumvent these non-helpful folks, it sure would be nice.

Thank you for a great program. If it could do scheduled backups better, I wouldn't have to kludge up my own routines.

Your product could be better if:

1) it made backup files with individual date and time stamps as part of the file name so I would have a separate daily history rather than information appended into one file.

2) I had a way to do incremental backups for data in the database.

3) If the Scheduled Backup .xml script actually worked on Windows 98.

Until then, I had hoped to write my own software, which I have done, and which works great on every website I have a MySQL database, except the one mentioned that uses MySQL v4.1.11.

Thank you so much.

FWIW – I do not have root access in any of the websites mentioned.

[a_edwall]

I just noticed that the MySQL ODBC driver has been updated from 3.51.08 to 3.51.11. Using this driver, my problem is solved. Apparently the 3.51.11 driver is matched to v4.1.xx of MySQL whereas the previous driver was not.

Lots of headaches for a simple solution.

Thank you.

[Author]

Posts