I use the DB connectivity toolkit from NI to connect to my mySQL database.
In my connect function , i have wired a username, password, and the udl file as inputs. Strangely, every so often (usually when i reboot the computer or wait about a half hour), i will get an error with the code "-2147287038" which isnt documented in the error codes library.
What is even stranger is when i regenerate the mysql.udl file, the error goes away, only to come back again a half hour later...
Any insight into what the problem is and how to fix it? The only thing i can think of is maybe the mySQL server is going away, and it needs something to kick it back... but a new file with the same filename and contents wouldnt seem to be the solution to that.