MySQL ADO
- From: "Dimitris Economou" <deco@xxxxxxx>
- Date: Wed, 11 Jan 2006 11:40:57 +0200
I am using MyODBC Driver 3.51 and ADO connection to connect to a MySQL 4.1
server using BCC6.
The MySQL Server runs on a WinXP platform.
When I connect through the LAN everything runs ok.
When I am using remote connection through the wLAN (ISDN connection to the
server) I may receive as a respond to a SELECT query that transfers to a
local ADO DataSet data from the server (randomly from 1min to 10 min)
"Server gone" message and I have to reconnect to execute the query. I
execute queries every 1min.
The MySQL wait_timeout is 8 hours.
The queries are small. Most of the times no records are returned.
Any suggestion?
.
- Follow-Ups:
- Re: MySQL ADO
- From: Dimitris Economou
- Re: MySQL ADO
- Prev by Date: Re: Timeout Expired
- Next by Date: Re: Only want to insert a record
- Previous by thread: Re: Timeout Expired
- Next by thread: Re: MySQL ADO
- Index(es):
Relevant Pages
- Re: hitting the limits
... relatively straight forward MySql database. ... 10K visitors a month and an
80Mb database are nothing. ... heavily loaded server. ... But the connection
will hang around until the garbage ... (comp.lang.php) - Re: VFP8 & MySQL
... > VFP functions like NVL to a MySQL one, definitely it made the switch very ...
> About your connection problem, I have mine setup as default for 100 ... As for the
server, we left it ... The server crashed and corrupted the database. ...
(microsoft.public.fox.programmer.exchange) - Re: Shorewall and MySQL problem - solved
... Well, now the system accepts any connection besides mysql for ip,ip,ip ...
It is a solution for mysql, but your server is now more at risk from ... firewall via poor
programming practices. ... (comp.os.linux.networking) - Re: VFP8 & MySQL
... Main Location and 3 branches (these are remotely accessing MySQL at the main ...
About your connection problem, I have mine setup as default for 100 ... As for the server,
we left it alone. ... The server crashed and corrupted the database. ... (microsoft.public.fox.programmer.exchange) - Re: Local Access database to shared PHP/MySql hosting export
... access to the db server. ... >> Long ago I was shown how Excel could query
data from a mysql ... >> beleived it used a mysql odbc driver that runs on
windows and knows how ... set up an odbc connection with the necessary details ...
(comp.lang.php)