Re: OBDC connect slow with ASP
Posted by:
Dustin S
Date: November 03, 2004 05:45PM
I had the same problem. It turns out that it was a DNS issue. I think when MySQL authenticates a user (at least with version 4.1) it "attempts to determine the host name of the IP address using a reverse lookup. If the client computer has a slow Domain Naming Service (DNS) server, or no DNS server, and the local HOSTS or LMHOSTS file on the computer does not contain the host name for the IP address of the SQL Server, the reverse lookup will time out after five seconds".
You can read more about this here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300420&gssnb=1
Anyways...make sure your server(s) are pointing to a fast DNS server and reverse lookups are working. This fixed my problem right up.
Hope this helps,
Dustin
Subject
Written By
Posted
February 07, 2005 01:28PM
Re: OBDC connect slow with ASP
November 03, 2004 05:45PM
November 07, 2004 05:39AM
November 29, 2004 01:57PM
November 30, 2004 05:30AM
December 02, 2004 01:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.