Connections problems. MyODBC bug?
am 09.11.2002 12:48:54 von Evgeni Vachkov
Hi,
Im running MySQL version 3.23.41 on a RH Linux 7.2 sever. When I am
trying to connect from Access 97 (MyODBC 2.50.39), I get the follofing
error message "ODBC -- call failed" and then another one: "[TCX][MyODBC]
Lost connection to MySQL server during query (#2013)". I tried also
connecting from another Linux box, using mysql. It was connecting OK.
Seems like a problem with MyODBC. Did a trace of MyODBC. File is shown
below:
Has anyone experienced a similar problem? A bug or misconfuguration?
Your help is appreciated!
Regards,
Evgeni Vachkov
-------------myodbc.log---------------------
| | >mysql_option
| | | enter: option: 0
| |
| | info: MyODBC Version 2.50.39 option_flag: 4 client_flag: 64
|
| >mysql_real_connect
| | enter: host: 192.168.31.12 db: test user: test
| | info: Server name: '192.168.31.12'. TCP sock: 3306
| | >vio_new
| | | enter: sd=312
| | | >_mymalloc
| | | | enter: Size: 84
| | | | exit: ptr: 6c70e38
| | | <_mymalloc
| |
| | >_mymalloc
| | | enter: Size: 8192
| | | exit: ptr: 6b6076c
| | <_mymalloc
| | >vio_fastsend
| | | exit: 0
| |
| | >vio_keepalive
| | | enter: sd=312 set_keep_alive=1
| |
| | >vio_is_blocking
| | | exit: 1
| |
| | >vio_read
| | | enter: sd=312 size=4
| | | exit: 0
| |
| | info: vio_read returned 0, errno: 0
| | error: Couldn't read packet: remain: 4 errno: 0 length: 0
alarmed: 0
| | error: Wrong connection or packet. fd: TCP/IP (312) len: -1
| | >end_server
| | | info: Net: TCP/IP (312)
| | | >vio_close
| | |
| | | >_myfree
| | | | enter: ptr: 6c70e38
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 6b6076c
| | | <_myfree
| | | >free_old_query
| | |
| |
| | error: message: 2013 (Lost connection to MySQL server during query)
| | >end_server
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >free_old_query
| | |
| |
| | >mysql_close
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| | | >_myfree
| | | | enter: ptr: 0
| | | <_myfree
| |
|
| >set_dbc_error
| | error: message: Lost connection to MySQL server during query
|
>SQLError
| enter: szErrorMsg: 6760da0
| error: Message: Lost connection to MySQL server during query
>SQLError
| enter: szErrorMsg: 67610a8
>SQLError
| enter: szErrorMsg: 67610a8
>SQLError
| enter: szErrorMsg: 67610a8
>SQLFreeConnect
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
| >_myfree
| | enter: ptr: 0
| <_myfree
>_myfree
| enter: ptr: 6c70a18
<_myfree
>_myfree
| enter: ptr: 6c708f8
<_myfree
>_myfree
| enter: ptr: 6c70a68
<_myfree
>TERMINATE
| safe: Maximum memory usage: 8282 bytes (9k)
-------------myodbc.log---------------------
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/ (the list archive)
To unsubscribe, e-mail
To unsubscribe from Yahoo! Groups version, e-mail myodbc-unsubscribe@yahoogroups.com
Re: Connections problems. MyODBC bug?
am 09.11.2002 19:29:58 von Venu
Evgeni Vachkov wrote:
> Hi,
> Im running MySQL version 3.23.41 on a RH Linux 7.2 sever. When I am
> trying to connect from Access 97 (MyODBC 2.50.39), I get the follofing
> error message "ODBC -- call failed" and then another one: "[TCX][MyODBC]
> Lost connection to MySQL server during query (#2013)". I tried also
> connecting from another Linux box, using mysql. It was connecting OK.
> Seems like a problem with MyODBC. Did a trace of MyODBC. File is shown
> below:
> Has anyone experienced a similar problem? A bug or misconfuguration?
> Your help is appreciated!
Please check the previous mail archieve to get rid of this error. Its
issue from RH glibc.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:6383:200211:lc igkpilgbmcgafhnbpl
Here is a updated glibc patch from Redhat which fixex this issue:
https://rhn.redhat.com/errata/RHSA-2002-197.html
Or you need to install the MySQL binary from MySQL instead of using it
from Redhat distribution.
>
>
> Regards,
> Evgeni Vachkov
>
> -------------myodbc.log---------------------
> | | >mysql_option
> | | | enter: option: 0
> | | mysql_real_connect
> | | enter: host: 192.168.31.12 db: test user: test
> | | info: Server name: '192.168.31.12'. TCP sock: 3306
> | | >vio_new
> | | | enter: sd=312
> | | | >_mymalloc
> | | | | enter: Size: 84
> | | | | exit: ptr: 6c70e38
> | | | <_mymalloc
> | | _mymalloc
> | | | enter: Size: 8192
> | | | exit: ptr: 6b6076c
> | | <_mymalloc
> | | >vio_fastsend
> | | | exit: 0
> | | vio_keepalive
> | | | enter: sd=312 set_keep_alive=1
> | | vio_is_blocking
> | | | exit: 1
> | | vio_read
> | | | enter: sd=312 size=4
> | | | exit: 0
> | | end_server
> | | | info: Net: TCP/IP (312)
> | | | >vio_close
> | | | _myfree
> | | | | enter: ptr: 6c70e38
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 6b6076c
> | | | <_myfree
> | | | >free_old_query
> | | | end_server
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >free_old_query
> | | | mysql_close
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | | >_myfree
> | | | | enter: ptr: 0
> | | | <_myfree
> | | set_dbc_error
> | | error: message: Lost connection to MySQL server during query
> | SQLError
>
> | enter: szErrorMsg: 6760da0
> | error: Message: Lost connection to MySQL server during query
> SQLError
>
> | enter: szErrorMsg: 67610a8
> SQLError
>
> | enter: szErrorMsg: 67610a8
> SQLError
>
> | enter: szErrorMsg: 67610a8
> SQLFreeConnect
>
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> | >_myfree
> | | enter: ptr: 0
> | <_myfree
> _myfree
>
> | enter: ptr: 6c70a18
> <_myfree
>
> >_myfree
>
> | enter: ptr: 6c708f8
> <_myfree
>
> >_myfree
>
> | enter: ptr: 6c70a68
> <_myfree
>
> >TERMINATE
>
> | safe: Maximum memory usage: 8282 bytes (9k)
>
> To unsubscribe from Yahoo! Groups version, e-mail
> myodbc-unsubscribe@yahoogroups.com
>
--
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306
<___/ www.mysql.com USA
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
http://lists.mysql.com/ (the list archive)
To unsubscribe, e-mail
To unsubscribe from Yahoo! Groups version, e-mail myodbc-unsubscribe@yahoogroups.com
Re: Connections problems
am 12.11.2005 16:19:45 von Henry
------=_NextPart_000_0003_01C5E7DF.915AAFD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
HI,=20
I am doing a VB project that connect to my website database directly. I =
am using MySql database server. I need to pack and deploy to other =
departments.Can I include the MyODBC driver in the VB setup so that the =
setup is seamless and the user don't have to bother to setup the MyODBC =
separately?
Thanks
Henry
------=_NextPart_000_0003_01C5E7DF.915AAFD0--