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.