Re: ODBC lost connection's

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
if you are trying to connect to sql server over internet or wan - then this is a problem. Even ping can show persistent connection - it is not, any drop of connection cause "Lost connection" error message

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


<shanec22@xxxxxxxxx> wrote in message news:cd9fea08-2bbd-4c55-ae77-6eee38afb9d3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Ok currently the error we are getting most often is…

ODBC - call failed
[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-log] Lost connection to MySQL
server during query (#2013)


According to MySQL they state the following on this issue
http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html

it appears that we may have a network issue, however after two runs on
two different PC’s running the following

ping [my server 1 ip] –n 5000 >h:\pinglog.txt

I have not seen any pings that did not make it through.

I am going to run the ping logs for a longer time frame but I need to
know if there is any software which can check the status of the
network to help pinpoint where the issue may be.

Thank you
Shane

.

Relevant Pages

  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help! Lost my internal network after installing Wireless ADSL modem/router.hub.WiFi
    ... before to set up a home network with the Wizard. ... Internet connection: Local Area Connection ... >>I have done the ping tests. ...
    (microsoft.public.windowsxp.network_web)
  • Re: XP & Win2K N/w blues
    ... >network in my office and behaves absolutely normal. ... But, when I ping from the XP to Win2K machine, the ping ... >Ethernet adapter Local Area Connection: ...
    (microsoft.public.windowsxp.network_web)
  • Re: Can not connect to internet after ME to XP upgrade
    ... Ping yahoo.com and yahoo.com 80 fails ... mentioned that this firewall needs to be reinstalled and I continued with it. ... Select Never dial a connection. ... Network card is "SMC EZ 10/100 SMC1211TX". ...
    (microsoft.public.windowsxp.network_web)
  • Re: self ping fails
    ... Badcomputer CAN'T ping its own IP address ... Badcomputer CAN ping other computers on the network ... I get an excellent connection in all permutations, ...
    (microsoft.public.windowsxp.network_web)