Bug #4244 bytefx.data + mysql + vb.net

• Submitted: 22 Jun 2004 7:59
• Modified: 22 Oct 2004 20:51
• Reporter: chia chee bu
• Status: Can't repeat
• Category: Connector / NET
• Severity: S2 (Serious)
• OS: Windows (windows xp)
• Assigned to: Reggie Burnett
• CPU Architecture: Any

[22 Jun 2004 7:59] chia chee bu

Description:
With below coding and occur error message:

##VB.NET ##

imports bytefx.data.common
imports bytefx.data.mysqlclient

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        Dim dbConn As New MySqlConnection
        dbConn.ConnectionString = "Data Source=localhost; Database=PGPData; User ID=root; Password="
        Dim strSQL As String = "SELECT * FROM mem_m"
        Dim da As New MySqlDataAdapter(strSQL, dbconn)
        Dim ds As DataSet = New DataSet
        Dim dv As DataView = New DataView

        Try
            da.Fill(ds)

            dv = ds.Tables(0).DefaultView

        Catch ex As Exception
            Label1.Text = ex.Message
        End Try
    End Sub

##Error Message ##
Message: "The DateTime represented by the string is out of range."

StackTrace:  at ByteFX.Data.MySqlClient.MySqlDataReader.Read()
   at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at MISNetPGP.Form3.Button4_Click(Object sender, EventArgs e) in G:\VBNETPRJ\vbMLMPGP\MISNetPGP\TestModule\Form3.vb:line 338"	

How to repeat:
no idea on this

Suggested fix:
If use MySQLDriverCS without this problem, but it with less document.

[22 Jun 2004 7:59] chia chee bu

table used by this code

Attachment: testMEM_M.sql.zip (application/x-zip-compressed, text), 781 bytes.

[2 Jul 2004 22:34] Reggie Burnett

Can you narrow this down to a particular row and send me the data types and values of that row?  What is happening here is that there is some data in a datetime column that the provider is not handling properly.

[22 Oct 2004 20:51] Reggie Burnett

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

I'm marking this closed because I have been unable to repeat.  If you can repeat this and send me the schema/data that shows this bug, I'll take another look.