MyODBC 3.51.06 dropping connections on Windows 2003 Server
Jiuying Zhou
I'd like to ask if anyone has experienced this problem and come up with a
work around. We have an application running on a Windows 2003 server (dual
Xeon CPU) that uses MyODBC (3.51.07) to connect to a MySQL database (4.0.17)
running on the same server. When large amount of data (sorry I haven't been
able to quantitate how much, but on the order of a few thousand rows) is
inserted into the database, the insert will proceed for a couple of thousand
rows, and then MyODBC will drop connection and report this error:
Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51
Driver]Can't connect to MySQL server on 'localhost' (10048)
Any help is appreciated!
*********************************************************
THIS ELECTRONIC MAIL MESSAGE AND ANY ATTACHMENT IS
CONFIDENTIAL AND MAY CONTAIN LEGALLY PRIVILEGED
INFORMATION INTENDED ONLY FOR THE USE OF THE INDIVIDUAL
OR INDIVIDUALS NAMED ABOVE.
If the reader is not the intended recipient, or the
employee or agent responsible to deliver it to the
intended recipient, you are hereby notified that any
dissemination, distribution or copying of this
communication is strictly prohibited. If you have
received this communication in error, please reply to the
sender to notify us of the error and delete the original
message. Thank You.
*********************************************************
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=myo...@freebsd.csie.nctu.edu.tw
Ian Neubert
> From: Jiuying Zhou [mailto:JZ...@CELGENE.com]
>
> Hi,
>
> I'd like to ask if anyone has experienced this problem and come
> up with a
> work around. We have an application running on a Windows 2003 server (dual
> Xeon CPU) that uses MyODBC (3.51.07) to connect to a MySQL
> database (4.0.17)
> running on the same server. When large amount of data (sorry I
> haven't been
> able to quantitate how much, but on the order of a few thousand rows) is
> inserted into the database, the insert will proceed for a couple
> of thousand
> rows, and then MyODBC will drop connection and report this error:
>
> Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51
> Driver]Can't connect to MySQL server on 'localhost' (10048)
>
> Any help is appreciated!
I am having this same problem on a Windows 2000 IIS ASP application
connecting to a Linux based MySQL 4.0.18 server using MyODBC Connector
3.51.16.
Have you, or anyone else found a solution to this problem? The connection
works fine most of the time, but it will randomly fail with:
""
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'xxx.xxx.xxx.xxx'
(10048)
""
A refresh of the ASP page in error seems to always work fine. Any thoughts?
.......................
Ian Neubert
Director of IS
TWAcomm.com, Inc.
http://www.twacomm.com/