Does not connect when compiled

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.:confused:

Is there any way to overcome this problem?

Thanks in advance for your time and trouble

Welcome to the Forums.

When its compiled does it run on your system ok or where is it running from?

Can you post your connection code?

Hi Robdog

The connection string is:

cnn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=serversite;" & _
"Port=3306;" & _
"DATABASE=mydb;" & _
"USER=myuserid;" & _
"Password=mypw;" & _
"OPTION=3;"

And yes I am running the program from the same computer where I am writing it.

and yhank you for your interest.

What event is your connection in? Form_Load or some other event? Could it be an ordering of firing events that when compiled is different then when stepping through the ide?