Is there a reason you are using the ADODB recordset with the MySql database connector? You might have some more luck with the integrated data readers etc built into the MySql connector.
There is a Data Reader that can loop through recordsets similar to opening the recordset that you are doing there just not the same with updating, adding or deleting rows, this is some modified code which might help you get up and running.
Imports MySql.Data.MySqlClient
Public Class Form1
Public conan As New MySqlConnection
Public dr as MySQLDataReader
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myDB = "DBNAME"
Dim myServer = "66.77.144.100"
Dim myUsername = "USer"
Dim myPassword = "12345"
Dim connectionString as string, sSQL as string
connectionString = "DATABASE=" & myDB & ";SERVER=" & myServer & ";user id="& myUsername & ";password=" & myPassword
If conan.State = ConnectionState.Closed Then
conan.ConnectionString = connectionString
conan.Open()
End If
sSQL = "SELECT * FROM deneme;"
Cmd = New MySqlCommand(sSQL, conan)
dr = Cmd.ExecuteReader()
While dr.Read
Response.Write dr("fieldname1")
End While
dr.Close()
End Sub
End Class