Re: MySQL ADO
- From: "Dimitris Economou" <deco@xxxxxxx>
- Date: Thu, 12 Jan 2006 16:46:23 +0200
Problem Solved,
Do not trust Crypto F320 router. When I disabled the firewall everything was
fine.
The F320 router uses Conexant chipset.
"Dimitris Economou" <deco@xxxxxxx> wrote in message
news:e3wV1LpFGHA.3912@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>
>
>
.
- References:
- MySQL ADO
- From: Dimitris Economou
- MySQL ADO
- Prev by Date: RE: HOW TO: Implement transaction in TableAdapter class
- Next by Date: Using Resync with ADO and complex SQL Query statement using left outer joins
- Previous by thread: MySQL ADO
- Next by thread: Create Index - Pls Help
- Index(es):
Relevant Pages
- Re: static routing
... Connections work going out from inside the router, ... I'll have to remove the
router and connect the server directly to the cable ... A static route has
been added that matches the subnet ... (microsoft.public.windows.server.networking) - Re: Connection from remote computer to network SQL Server
... There is no firewall on the W2K machine acting as the SQL server. ... I tried
making the SQL machine a "trusted" on the router. ... connection works. ...
To find the IP address of your computer inside the network, ... (microsoft.public.access.adp.sqlserver) - Re: Urgent! New router and big disaster
... seleting full time broadband connection. ... Les Connor [SBS Community Member
- SBS MVP] ... check the router as well and unless I missed a firewall setting on it, ...
Anyway the Server Ipconfig /all is this... ... (microsoft.public.windows.server.sbs) - Re: Still cant connect to RWW or OWA remotely
... As for error messages when I fail to access RWW with the laptop, ... the server)
when you fail to access RWW with the laptop? ... I tried accessing RWW from my laptop connected
to a router ... match the broadband connection, the two NIC firewall, the remote
... (microsoft.public.windows.server.sbs) - Re: Urgent! New router and big disaster
... DNS on your server is broken. ... Les Connor [SBS Community Member -
SBS MVP] ... and put in the ip of the router. ... The local router has the broadband
connection ... (microsoft.public.windows.server.sbs)
