Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tom Saddul
  Where is Tom Saddul?
 Paranaque
 Philippines
 Tom Saddul
 To: Apple Draniel
  Where is Apple Draniel?
 Bucharest
 Romania
 Apple Draniel
 Tags
Subject: RE: Connection Time too long mysql
Thread ID: 228697 Message ID: 228717 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, May 21, 2009 2:04:26 AM         
   


It might be in the configuration of MySQL Database Server itself especially if you are using Windows Operating Systems.

Put this option under [mysqld] of your my.ini file

skip-name-resolve

OR

Run MySQL Administrator, Select Startup Variables, Click Advanced Networking Tab, then Check Disable Name Resolving


---------------------------

As an additional advice, refrain from using Remote Views... Use SQL-Pass through or CURSORADAPTER()

ENTIRE THREAD

Connection Time too long mysql Posted by Apple Draniel @ 5/20/2009 9:18:56 PM
RE: Connection Time too long mysql Posted by Tom Saddul @ 5/21/2009 2:04:26 AM
RE: Connection Time too long mysql Posted by anand kulkarni @ 5/29/2009 11:17:45 AM