I have a server which uses MySQL and supports many clients, and everything works perfectly fine when the MySQL database is on the same machine as the server.
However, when it's on another machine, due to what I believe is the slow connection there are several requests from different clients all doing MySQL queries, which throws null exceptions and "Operation can't be done after resultset close" exceptions.
Due to the nature of the server there are several running, each on different machines, but all connecting to the same master DB. Due to this I need to fix the remote MySQL access, and I believe threading it would work.
Each client connection to the server cannot have it's own SQLDatabase object (Which does the queries) as that lags up the server quite badly.
Any ideas? Ideally I want to be able to thread the executeQuery MySQL function somehow.