MySQL and VB6

[PaulTilley]

Hi All

I am using the following connection string:

ConnectionString = Driver={MySQL ODBC 5.1 Driver};Server=XXXX;Port=3306;Database=XXXX;User=XXXX; Password=XXXX;Option=3;

Which works fine.

If the MySQL database server is not there, the VB6 application opens the MySQL Connector window.
Is there any way I can trap/prevent this and handle the error myself ie msgbox/shut down app etc?


Thanks
Paul

[jggtz]

It would be better if you post the whole open procedure

[PaulTilley]

Well...... Thats where I am lazy really.....

I am using the Data Environment and do the following:

DE1.Conn1.ConnectionString = gStrConnectionString

DE1.Commands("Fire").CommandText = "SET SESSION wait_timeout=86400"
DE1.Commands("Fire").Execute

Does this make things any clearer?


Paul

[jggtz]

AFAIK
If we use data environment to connect to a data provider it will use its own error handling and that's why it is asking for new credentials to establish connection again
If we use our own code we will be able to handle the error...

[PaulTilley]

Does this mean that I have no way of trapping the error then?

[jggtz]

That's my opinion, but I haven't much experience with data environment
Let's see if there're others' opinion