MySQL Bugs: #24054: ODBC Connector crashes on executing any select statement using ADO

Bug #24054	ODBC Connector crashes on executing any select statement using ADO
Submitted:	7 Nov 2006 17:31	Modified:	20 Nov 2006 11:07
Reporter:	Marek Srom	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.0.6	OS:	Microsoft Windows (Win XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	ODBC5-RC

Description:
DB 5.1 (5.0 also) - using ADO / MDAC 2.8 - execute "select * from any table" => crash of visual studio - error in module myodbcdriver5.dll

How to repeat:
code in VB:

  Dim conn As New ADODB.Connection
  conn.Open "DRIVER={MySQL Connector/ODBC v5 Driver};SERVER=localhost;DATABASE=mydb;UID=root;PWD=xxx; OPTION=3;"
  conn.Execute "create table aaa(x int)"
  Set rs = conn.Execute("select * from aaa") '==CRASH
  rs.Close
  Set rs = Nothing
  conn.Close
  Set conn = Nothing

Hi Marek and thanks for your report.
I am unable to crash VS nor am I able to trace problem to MyODBC 5 driver but the problem exists: Exception is rised "at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)" as SQLDescribeColW() fails on Integer column...

I would like if you can provide more info on your environment regarding VS crahs...

VB Project

Attachment: mysql.zip (application/x-zip-compressed, text), 5.57 KiB.

In files is project and compiled exe - to the textbox eneter root pwd.
I have Visual Studio 6.0 SP6, Win XP SP2, all MS updates, ODBC 5.0.6, DB last 5.1 beta. I had earlier versions before, tried to uninstall all and install newly but problem persist. ADO is version 2.8, problem is the same when calling from ASP page on IIS - reports unspecified error. Tell me what more u want to know. I can try to install it on another machine if the problem persits.

Hi Marek. As you can see from my first answer, I am aware of this problem for some time now... Our connecotr/ODBC team is working on it. Can you please try with 5.00.07?

As for test case, VS2005 has problems opening it... Next time, please post *all* of project files (and not the executable).

Reproduce crash

Attachment: test.vbs (application/octet-stream, text), 389 bytes.

Hi,
i tested it with 5.0.07 ODBC connector, tested on another machine w2k where mysql has never been - the same result. I added simple vbs script - just edit for a password change and run.

Hi Marek. Here we have two problems:
1) Provider=MSDASQL.1; -> doesn't work
Const cConnectionString= "DRIVER={MySQL Connector/ODBC v5};SERVER=localhost;DATABASE=mysql;UID=root;PWD=; OPTION=3;" -> works
'Const cConnectionString= "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Provider=MySQLProv;DRIVER={MySQL connector/ODBC v5};SERVER=localhost;DATABASE=test;USER=root;PASSWORD="';OPTION=16387;Initial Catalog=" -> doesn't work

2) I'm not sure but it seems that either/both SQLTables(W) and SQLColumns(W) are failing

See attached files for details.

Test case

Attachment: Bug24054.vbs (application/octet-stream, text), 2.20 KiB.

DM trace

Attachment: Bug-24065-SQL.zip (application/x-zip-compressed, text), 2.48 KiB.

MyODBC5 trace

Attachment: Bug-24065-MYODBC5.zip (application/x-zip-compressed, text), 5.67 KiB.

I forgot to mention, the error thrown (80004005) is thrown for almost everything that goes wrong so it doesn't help at all...
Attached logs are tagged with wrong bug nr, should be 24054.

This is a duplicate of Bug#17604.