I am writing a program using VB6. It uses a Mysql database on a remote server and I am using MySQL ODBC 3.51 to connect to it.
I have used several connection strings and they all work fine when I am testing and debugging the program; but it does not connect to the database once the program is compiled.

Is there any way to overcome this problem?

Thanks in advance for your time and trouble