ODBC lost connection's

[shanec22]

Access novice here looking for some advice.

We run Office 2007 on PC's running windows XP.

we have two mirrored servers running server 2003

i have front end databases on the PC's and back end (tables only) on
the servers.

we also connect to some tables via ODBC (version 3.51.27) and that is
where my issue is.

i have "on event" code which run's in the front end database's either
a update query that updates the linked ODBC table, or and append query
that transfers records from a linked table on the server to the linked
ODBC table.

The problem is that we get intermitent error's when those run.

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

if i wait a few second and run the event again it work's just fine,
sometimes we can go hours without it happening and other times it
happens on every other attempt. All of our PC's have this issue, but
since it happens at random times and on random machines it has become
difficult to determine the issue.

if anyone has a direction to look that would help me resolve this it
would be greatly appreciated.

 

[Alex Dybenko]

Hi,
perhaps mirrored servers the source of problem, have you tried on only one?
also look here:
http://accessblog.net/2008/05/why-sql-server-drops-connection.html

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

 

[shanec22]

Our PC's are set to only connect to one server, and the connection
issue's we are having are not with the tables on my server's but on a
linked table on a server hosted by the company that host's my web
site.

DFS server1 active=yes
DFS server 2 active= no

but i can check with the people that set up the network.

In regards to link you provided, i am just not skilled enough to
completly understand what the blog is saying to do. Any chance you
can put it general terms?

Thank you
Shane

 

[shanec22]

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

 

[Alex Dybenko]

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]

What would you reccomend, we send updates to records on our web site
via queries and VBA code events. We also copy records from the web
site table and paste them into our tables. Is there a different
option other then MYSQL ODBC connection to perform that?

Thank you
Shane

 

[Alex Dybenko]

Hi,
well, to send updates - you can upload updates as sql text, or make some web
service.
then you can download database from web server and restore it locally
You can also consider replication if it exists on mysql

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