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
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.