This worked for me when I was having the same problem. Add the "Conn.CommandTimeout = seconds" line after you create the connection:
Conn.Open "DSN=sql.mySQL.com;UID=sa......
Conn.CommandTimeout = 60
The 60 stands for seconds. You might need more time for longer queries. Good Luck.
--Tim
Would you believe I haven't been there before? Now I feel really stupid. I found the checkbox that allows anonymous access--it was checked. (Can you tell someone else setup our internet stuff?) I'll monitor for a day or two and see if that helps. Thanks so much for the hint. --Tim
My Win2K webserver has SP3 and all the pre-SP4 patches, but my Event viewer gets filled with the following events:
"Message delivery to the remote domain 'yahoo.co.kr' failed for the following reason: the remote server did not respond to a connection attempt."
The remote domain...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.