RE: ActiveX control "delays" when accessing mySQL database when internet isdown

Greg,

If it is a DNS issue, then those settings should have done the trick.
However, on a further note, is the machine Mysql is running on multi-homed
i.e. does it have multiple network cards/support multiple IP addresses. If
it does, then try binding the Mysql server to each different IP address
that is supported (in turn) to see if this makes a difference.

Use the following in your ini file:

bind-address=xxx.xxx.xxx.xxx

Tim.

-----Original Message-----
From: Greg Quinn [mailto:greg@i-online.co.za]
Sent: 24 March 2005 20:40
To: win32@lists.mysql.com
Subject: Re: ActiveX control 'delays' when accessing mySQL database when
internet is down

Putting

skip-name-resolve
skip-host-cache

in my .ini file kind of half helps this problem out, it brings down the
delay from about 1 minute down to 5 seconds. But this delay still
exists...

This is definately something to do with DNS, as proposed by our network
administrator...

Anything else I can check for?


----- Original Message -----
From: "Greg Quinn"
To:
Sent: Thursday, March 17, 2005 1:08 PM
Subject: ActiveX control 'delays' when accessing mySQL database when
internet is down


> We are having this strange problem with an ActiveX control of ours, in
> fact all of our web application's activeX controls have the same
> problem.
>
> On some networks, when the internet connection is down, the control
> takes about 20-30 seconds to open.
>
> The controls all reference a MySQL database directly using a
> connection string with an ip address.
>
> i.e = "server=192.168.0.1;database=mydb" etc.
>
> What is causing this? On some networks this doesn't happen?
>
> Thanks
> ____________________________________________________________ __
> http://www.webmail.co.za the South African FREE email service
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=tim.lloyd@biomni.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org