Error:This property is read only now


cnMySql.CursorDriver = rdUseOdbc
cnMySql.Connect = "uid=root; pwd=password; server=127.0.0.1;" & _
"driver={MySQL ODBC 3.51 Driver}; database=flight;"

cnMySql.EstablishConnection


With rdoQry
.Name = "selectUsers"
.SQL = "select * from users where id='" + Text1.Text + "' and pwd='" + Text2.Text + "'"
.RowsetSize = 1
Set .ActiveConnection = cnMySql
Set rdoRs = .OpenResultset(rdOpenStatic, rdConcurRowVer)
End With

With rdoRs
If .EOF Then
MsgBox ("Username or password is invalid")
Else
MsgBox ("Login Successful")
Unload Me

End If


End With


************************************************** ****
What i have done is, i wrote this code to access MySql from vb6 , it works fine for the first time when i enter the username and password, but when i click it the 2nd time, it throws an error, i am stuck on this , please somebody flush this problem and give me a solution with explanation . Thank you.