Posted by Robert G Laurin on July 17, 2014 at 11:42:00:
In Reply to: Re: ODBC Query timeout expired posted by Barbara Brazil on July 17, 2014 at 10:00:46:
I did a lot of ODBC, been using it for a few years. We are in the process of switching everything to SQL Gateway in Comet32.
ODBC is simply awful! It is picky and if you get a timeout, it's because it failed.
It is very picky about having a semicolon ';' at the end and about the data structure. The format has to be perfect!
I suggest you start with the sample programs (if there are any) and work from there. Once the sample works, you know you have a good connection. Then try making monior changes to the layout or to the database and keep going.
MySQL can also be tricky to configure. You want to retain maximum security with the permissions and limit IPs that access the data.
If you didn't yet, I suggest you get SQLYOG (free community edition) to test your queries and refine them until they work for you.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.