database connectivity timeout

[Tim_Butler]

Hello,

   I'm using the database connectivity toolkit to connect to a MySQL database. If the database isn't there or there is a mistake in an SQL query after I have connected my program takes 15s (the default) to realise. I've tried wiring different values to the connection timeout node but this doesn't seem to make any difference whatsoever. I've hacked the first problem by pinging the machine with the DB on before trying to connect as suggested in another post, but this doesn't help if I screw up my INSERT syntax... any ideas what could be wrong?

       Cheers,

              Tim

[alpha1]

Hi Tim,

You should be able to use the command timeout (s) parameter of the DB Tools Set Properties VI of the Database Connectivity Toolkit to set the maximum time to wait for a command to execute, in seconds.

[Tim_Butler]

Thanks Imtiaz, that's sorted my problems - I don't suppose you have any idea why the timeout value I'm wiring to the Open Connection VI isn't working? I can't set the connection properties as you suggest until after the connection is open so I'm still having to check for the presence of the DB machine before opening.

   Cheers,

           Tim

[rolfk]

That timeout value is explicitedly for the Open operation itself. The server could be slow to answer, or behind many low speed network connections or as in your first problem not even listening at the address you provided, so there is a use for that.

Message Edited by rolfk on 11-22-2009 01:44 PM

[LabBEAN]

I had the same problem with the database connection timeout not working, so I created this VI to check for connectivity before opening a connection.

Message Edited by LabBEAN on 02-19-2010 06:17 PM