Paul McNett wrote:
> MB Software Solutions General Account wrote:
>> My ISP's MySQL database appears to have a problem.  I can't conect to 
>> it, and in fact, my attempts just "hang."
> 
> Sounds like a firewall issue, either on your end or on their end. Go to 
> a terminal and type "telnet <ip> 3306" and see if you get a response, or 
> if that hangs. If it hangs, check your firewall to make sure it allows 
> tcp port 3306 outbound.

Fails saying "Could not open connection to the host, on the port 3306: 
Connect failed"

> 
> 
>> In my VFP9SP1 app, I've set the ConnectTimeout value to be 5, yet the 
>> SQLSTRINGCONNECT line afterwards just hangs.
>>
>> Why doesn't it timeout as directed?
> 
> I could never get the timeout in vfp to work either.

I told my client (before telling him I could rewrite it to avoid the issue):

"The software is supposed to be able to continue without that 
constraint.  This was designed to be that way so as to avoid any kind of 
hangups. I'm surprised that the software is not functioning that way. 
I'm doing the appropriate commands to timeout the connection at 5 
seconds...not sure why it's not doing as instructed.  Perhaps a flaw in 
the Microsoft product used to develop this software."


Sounds like perhaps the ISP has "raised its shields" with some sort of 
firewall change on their end.  ??

Thanks for the comments, all!


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to