Bug #17604 Crash when select statement
Submitted: 21 Feb 2006 6:05 Modified: 5 Feb 2007 5:50
Reporter: hady ginanjar Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.0 OS:Microsoft Windows (Win 98 / Win XP)
Assigned to: Jess Balint CPU Architecture:Any
Tags: ODBC5-RC

[21 Feb 2006 6:05] hady ginanjar
Description:
MySql always crash when select staement. how to  make select statement in mysql 5.0?

How to repeat:
MySql always crash when select staement. how to  make select statement in mysql 5.0?

Suggested fix:
please fix this problem
[21 Feb 2006 10:45] Valeriy Kravchuk
What exact versions of MySQL server and MyODBC do you use? What exact SELECT crashes for you?
[22 Feb 2006 11:28] hady ginanjar
I use mysql server v 5.0. And myodbc v.5. Please help me.
[23 Feb 2006 9:54] Valeriy Kravchuk
If there was a crash of MySQL server, there should be something in its error log. Please, upload your server error log to this report using the File tab.
[24 Feb 2006 6:16] hady ginanjar
Error log is :
VB6 caused an invalid page fault in
module MYODBC~1.DLL at 017f:10023b26.
Registers:
EAX=00000000 CS=017f EIP=10023b26 EFLGS=00010206
EBX=00000000 SS=0187 ESP=007fee44 EBP=007fee44
ECX=0000000a DS=0187 ESI=047d09a0 FS=1317
EDX=00000000 ES=0187 EDI=047d08f4 GS=0000
Bytes at CS:EIP:
c7 40 1c 00 00 00 00 5d c3 cc 55 8b ec 51 0f bf 
Stack dump:
007fee84 100183b8 00000000 00000024 bff7a3a0 00000019 0000000a 0000000a 00005dc2 00000000 0000000a 0000000a 0000000a 0000000a 0000000a 0000000a 
----
this erro appear when statement "select * from table1"
[24 Feb 2006 11:10] Valeriy Kravchuk
OK, so it myodbc*.dll that access improper address. Can you connect to your server with mysql command line client and execute the same SELECT? Have you tried to "Test" DSN when you created it? Is your MyODBC version 5.0.0-alpha?
[25 Feb 2006 3:03] hady ginanjar
Yes, I can, but still error when SELECT statement. When i create DSN and test connection is OK. Right i use MyODBC version 5.0.0-alpha. how to solve this problem.
[25 Feb 2006 21:18] Valeriy Kravchuk
Verified just as described on XP. I was also able to Test connection to 5.0.18-nt, but SELECT leads (any) ODBC application to crash. 3.51.12 works great for me.
[27 Feb 2006 5:04] hady ginanjar
I already test in XP, still crash when i select statement. in 3.51.12 version can't connect to mysql 5.0, can it ? so how to connect and run well in mysql 5.0 ?

thanks,
hady
[1 Jun 2006 7:59] hady ginanjar
Dear MySQl Team,

	Please help me. My VB always crash when select statement. 

Regards,
Hady
[2 Feb 2007 9:04] Tonci Grgin
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/
[5 Feb 2007 5:50] hady ginanjar
dear all,

still error, error is [MySQL][MyODBC 5.00.06][MySQL] 2014 Commands out of sync; you can't run this command now. What should i do. syntax is "select * from userpassword where username= '" & txtUsername & "'", dB, adOpenDynamic, adLockOptimistic". anyoen can help me..

Tks
Hady
[5 Feb 2007 5:56] Jess Balint
Hady -

Please update your driver installation to the latest version, 5.00.11.