Bug #32145 Error while executing Select query
Submitted: 6 Nov 2007 13:49 Modified: 6 Nov 2007 15:39
Reporter: Saroj Kudtarkar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:5.0.37-community-nt OS:Windows (XP professional)
Assigned to: CPU Architecture:Any

[6 Nov 2007 13:49] Saroj Kudtarkar
Description:
I have a table while in MYSQL which does not have datetime field but when i execute the query i receive error as "String was not recognized as valid DateTime"

How to repeat:
Dim strSQLQuery As String
Dim cmdMySQl As New MySQLDriverCS.MySQLCommand
Dim dsDocVersion  As DataSet

dsDocVersion = New DataSet
            strSQLQuery = "Select * from Version_Master;"

            cmdMySQl.Connection = cn
            cmdMySQl.CommandType = CommandType.Text
            cmdMySQl.CommandText = strSQLQuery 

            Dim adpMySql1 As New MySQLDriverCS.MySQLDataAdapter(cmdMySQl)
            dsDocVersion.Clear()
            adpMySql.Fill(dsDocVersion, "Ver")
[6 Nov 2007 15:39] Hartmut Holzgraefe
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.