Does not connect when compiled

[Jose A]

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

[RobDog888]

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?

[Jose A]

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.

[RobDog888]

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?