Bug #35880 | Failure to retrieve data from the database mysql or information_schema with ODBC | ||
---|---|---|---|
Submitted: | 7 Apr 2008 14:47 | Modified: | 29 May 2015 9:16 |
Reporter: | deng jack | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | 5.1.3 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[7 Apr 2008 14:47]
deng jack
[8 Apr 2008 6:43]
Tonci Grgin
Hi Deng and thanks for your report. Verified just as described against '6.0.5-alpha-nt-debug-log'. Notes: Using 5.1 server one gets no error. Using any other database but 'mysql'/'I__S' with server 6.0 one gets no error (this could be due to different structure of "ordinary" tables (less fields) but I didn't investigate further as it seems important to deal with this bug ASAP). I used mysql.user table for testing with 6.0.
[9 Apr 2008 8:49]
deng jack
Another bug? Failure to execute specific MySQL Statements with ODBC driver. On the other hand, when I started MySQL Server 6.0.4 and tried to excute MySQL Statement "SHOW CREATE TABLE"(and other "SHOW" Statements) with ODBC driver in my Visual FoxPro application, my application crashed. And the same thing came up in Microsft Visual Basic application. I could not conclude whether associate it with the Bug#35880. But if I start the MySQL Server 5.0, I would succeed. How to repeat: 1. Start MySQL server(version 6.0.4). 2. Start Visual Basic 6.0 and create a new standard EXE project. 3. Add a reference of "Microsoft ActiveX Data Objects 2.x Library" to the project. 4. Draw a button named "Command1" on the form. 5. Double click the button "Command1" and paste following code to overwrite it's click event routine: Private Sub Command1_Click() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim rsfield As ADODB.Field Dim strResult As String 'Connect to MySQL server using MySQL ODBC 5.1.3 Driver Set conn = New ADODB.Connection conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=yourDB;UID=user;PWD=password;OPTION=3" conn.Open 'Excute statement Set rs = conn.Execute("SHOW CREATE TABLE yourTable") For Each rsfield In rs.Fields strResult = strResult & rsfield.Name & ": " & rsfield.Value & vbCrLf Next conn.Close MsgBox strResult End Sub 6. Press the key F5 to start debugging the project. Click the button "Command1", now Microsoft Visual Basic would crash.
[9 Apr 2008 8:54]
deng jack
Another bug? Failure to execute specific MySQL Statements with ODBC driver. On the other hand, when I started MySQL Server 6.0.4 and tried to excute MySQL Statement "SHOW CREATE TABLE"(and other "SHOW" Statements) with ODBC driver in my Visual FoxPro application, my application crashed. And the same thing came up in Microsft Visual Basic application. I could not conclude whether associate it with the Bug#35880. But if I start the MySQL Server 5.0, I would succeed. How to repeat: 1. Start MySQL server(version 6.0.4). 2. Start Visual Basic 6.0 and create a new standard EXE project. 3. Add a reference of "Microsoft ActiveX Data Objects 2.x Library" to the project. 4. Draw a button named "Command1" on the form. 5. Double click the button "Command1" and paste following code to overwrite it's click event routine: Private Sub Command1_Click() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim rsfield As ADODB.Field Dim strResult As String 'Connect to MySQL server using MySQL ODBC 5.1.3 Driver Set conn = New ADODB.Connection conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=yourDB;UID=user;PWD=password;OPTION=3" conn.Open 'Excute statement Set rs = conn.Execute("SHOW CREATE TABLE yourTable") For Each rsfield In rs.Fields strResult = strResult & rsfield.Name & ": " & rsfield.Value & vbCrLf Next conn.Close MsgBox strResult End Sub 6. Press the key F5 to start debugging the project. Click the button "Command1", now Microsoft Visual Basic would crash.
[14 May 2008 0:46]
Jim Winstead
This is probably a problem of the server returning data using character sets (like the new 4-byte UTF-8) that the client does not understand. Recompiling the driver with the client library from MySQL 6.0 should help.
[3 Dec 2010 9:21]
Bogdan Degtyariov
MyODBC 5.1.8 passes the test with MySQL 5.5.7-rc. I did not specify any special character set options. I am not sure if we should continue with fixing the bug for mysql server 6.0.
[29 May 2015 9:16]
Chiranjeevi Battula
Hello deng jack, Thank you for your feedback. I tried to reproduce the issue at my end using Visual Studio 2013 (VB.Net) and MySQL ODBC 5.3.4 but couldn't trace out any issue in excute MySQL Statement "SHOW CREATE TABLE". Could you please try the latest version of MySQL ODBC 5.3.4 and feel free to open the bug if it is not working. Thanks, Chiranjeevi.