RE: ActiveX control 'delays' when accessing mySQL database when internet is down - Tim....@biomni.com - com.mysql.lists.win32

3 messages in com.mysql.lists.win32RE: ActiveX control 'delays' when acc...

From	Sent On	Attachments
Greg Quinn	17 Mar 2005 03:07
Greg Quinn	24 Mar 2005 12:39
Tim....@biomni.com	29 Mar 2005 00:25

Subject:	RE: ActiveX control 'delays' when accessing mySQL database when internet is down
From:	Tim....@biomni.com (Tim....@biomni.com)
Date:	03/29/2005 12:25:15 AM
List:	com.mysql.lists.win32

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:gr...@i-online.co.za] Sent: 24 March 2005 20:40 To: win...@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?

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