Retry Mysql ADO connection

Hello, I work on a VB6 program that connects to a MYSQL database through ADO 1000s of times a day. Multiple versions of this program run at a time on different machines.

About once a day during one of the Connects, it will debug and not find the MySQL server.

Different ones each time. No consistency. What I want to happen on any of these is to just retry over and over again until it succeeds.

How can I do that? Any tips?

Any MYSQL ODBC connector settings that may help? Anyway to track down exactly why?

Thanks.

It is preferable to use a native OLEDB Provider instead of an old ODBC Driver.

I'm not sure all of the Connection parameters in ADO get passed through the OLEDB-ODBC shim to an ODBC Driver.

In either case you might try setting the Connection's ConnectionTimeout longer than the default (15 seconds). For retrying you're on your own though.