MySQL Forums
Forum List  »  General

error: malformed packet is a bug?
Posted by: semseddinm
Date: February 22, 2005 11:01AM

hi, i use mysql 4.1.7 on a windows 2000 machine. (myodbc3.51)
i'm using ado & visual basic 6 to connect mysql server. please examine code below: that code generates an "malformed packet" error. but if i add a "where" or "limit" clause to the sql statement it works well.
is it a bug in mysql/myodbc/ado?

regards,

    oCON.ConnectionString = "dsn=mydsn"
    oCON.CursorLocation = adUseClient '(or =adUseServer) 
    oCON.CommandTimeout = 30
    oCON.Mode = adModeRead
    oCON.Open    

    oRS.Open "select * from table", oCON, adOpenKeyset, adLockReadOnly 'ERROR
    oRS.Open "select * from table where 1=1", oCON, adOpenKeyset, adLockReadOnly 'ERROR 'WORKS
    oRS.Open "select * from table limit 10000000", oCON, adOpenKeyset, adLockReadOnly 'WORKS


    Do While Not oRS.EOF
        Debug.Print oRS(0).Value
        oRS.MoveNext
    Loop

    oRS.Close
    oCON.Close

Options: ReplyQuote


Subject
Written By
Posted
error: malformed packet is a bug?
February 22, 2005 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.