RE: Connection Time too long mysql (Posted by Tom Saddul) - www.foxite.com

From: Tom Saddul


	Manila Philippines
	Tom Saddul

To: Apple Draniel


	Bucharest Romania
	Apple Draniel

Tags

Connection Time too long mysql Tom Saddul Connection Time long mysql

Subject:	RE: Connection Time too long mysql
Thread ID:	228697	Message ID:	228717	# Views:	46	# 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()

Tip: click here to scan for Windows Registry Errors and Optimize PC performance

COMPLETE 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