Bug #13681 Delphi crashes away w/o error when database item connected = true
Submitted: 1 Oct 2005 10:29 Modified: 13 Apr 2007 6:41
Reporter: KAZANCI ibrahim Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.0 OS:Windows (WinXP SP2)
Assigned to: Jess Balint CPU Architecture:Any
Tags: qc

[1 Oct 2005 10:29] KAZANCI ibrahim
Description:
When try to get tdatabase component Connected = True wait for 1 or 2 seconds and Delphi closes suddenly without any error.

I tried with MYSQL 4.1 and MySQL 5.0.6 beta. On both of them same thing happen.

Same connection type working successfully with MySQL ODBC 3.51 (on MySQL 4.1 and 5.0.6) and Delphi 5

How to repeat:
i installed MySQL Connector/ODBC 5.0

from Control Panel - odbc - i added a datasource (save with name myodbc5) with selecting MySQL Connector/ODBC v5. 

I tested connection (I get "Success; Connection was made!" message).

Save and exit from odbc management.

From delphi create a new application and drop a tdatabase component on a form.

Make these settings while tdatabase component selected from object inspector:

DatabaseName : data
DriverName : MySQL Connector/ODBC v5
LoginPrompt : False

Right Click TDatabase
Select Database Editor...
on Paramater Override field type paste the following:

DATABASE NAME=mysql
USER NAME=root
ODBC DSN=myodbc5
PASSWORD=xxx

Click OK

try to Connect.

i think delphi application just disappeared.

Same connection type working with odbc 3.51

Suggested fix:
i cant use odbc 3.51 for reason of it doesn't support or doesn't understand datetime parameters on utf-8 databases or OS that uses Turkish. (This is another bug.)

#10518
#5395
#1026
[2 Oct 2005 10:33] Vasily Kishkin
Thanks for bug report. I verified the bug on Windows 2003, Delphi 7.0.
[27 Oct 2005 13:56] Daniel Moro
I verify too this bug :/

some forecast for fix it?
[4 Mar 2006 14:46] Philippe LE MOULEC
I had the same problem, then i am going to try MyODBC 3.51.12
[13 Apr 2007 6:41] Tonci Grgin
Hi Ibrahim.

I am unable to repeat the problem with:
 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - c/ODBC 5, mysql-connector-odbc-5.0-win32-nightly-20070411, System DSN
 - Delphi6, TDatabase w/wo Login prompt, accounts w/wo password, in IDE

You can get the driver from:
http://downloads.mysql.com/snapshots/mysql-connector-odbc-5.0/

As everything works fine now, I'm closing this report.