Using LV 7.1 and an Active-X based ODBC Connection scheme to a MySQL database which has worked flawlessly up until now. I've just written an application which accesses the database to generate a 'recipe' for our operators to follow. This is poked into a multicolumn listbox, and works perfectly from the compiled version. However, when I'm running the very same program in the development envirnment, I will get an error which indicates I have lost the connection to the database. Never happened from the built versions, and yes, I'm running exactly the same code. This is irritating, as when I'm trying to debug the SQL pieces, the code crashes. Happily, the compiled versions are working, but it makes me nervous when programs crash like this.
I am doing a listbox refresh every 60s or so, which involves accessing the database, reading a large chunk and displaying it. Im' also doing an ODBC conncetion check every 2s, and possibly some other database access depending on the operator input. MySQL is set up so that I can have 100 threads open at once, and I never approach that. I always open, do command, then close and destroy connections.
All I can think of is that there is a difference in the timing and the database access between the developement environment and the compiled versions.
Any thoughts anyone?