MySQL Bugs: #12775: catastrophic failure/ADO/ODBC5/Delphi5

Bug #12775	catastrophic failure/ADO/ODBC5/Delphi5
Submitted:	24 Aug 2005 5:10	Modified:	25 Oct 2005 15:01
Reporter:	Chagh	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5	OS:	Windows (win xp sp2)
Assigned to:		CPU Architecture:	Any

Description:

An error :"catastrophic failure" is given when trying to execute query/call sp from Delphi 5 using ADO and ODBC 5.
(connection string:"Provider=MSDASQL.1;Persist Security Info=False;User ID={UID};Extended Properties="DRIVER={MySQL Connector/ODBC v5};DESC=;DATABASE={dbname};SERVER=localhost;UID={UID};PASSWORD={pwd};PORT=;option=16387;STMT=;";Initial Catalog={dbname}")

How to repeat:
1. install ODBC 5 
2. create a new ADO connection in Delphi 5
3. build the ADO connection using connection string:"Provider=MSDASQL.1;Persist Security Info=False;User ID={UID};Extended Properties="DRIVER={MySQL Connector/ODBC v5};DESC=;DATABASE={dbname};SERVER=localhost;UID={UID};PASSWORD={pwd};PORT=;option=16387;STMT=;";Initial Catalog={dbname}"
4. create an ADOquery/SP
5. run the delphi app.

Suggested fix:
i don't know!

Could you please say me what is happend when you try to set "Connected" to true in ADOConnection ?

it is true when i build it, i mean i test the connection when building it(i do not know much things about Delphi). in the build window, testing the connection succeeds if i don't choose database name. but it gives me an error if i choose the database name(i think this is 'cause of my connection string. this occurs with ODBC 3.51.11 also)
any way i can connect to DB but i can not do anything more.

Thanx
Chagh

I would like to say I have an error when I'm trying to open connection. OK. Anyway this is bug.

This is a known problem in c/odbc v5 (alpha-1) and will be corrected in a future release. The solution for now is to use c/odbc v3.51.12 or newer. Thanks for the bug report.