Happy holidays all;

I'm trying to connect an VB-6.0 application to a remote MysQL DB and am running into difficulty. In particular I get an:

'Runtime error 3709': Connection cannot be used to perform operation. It may be closed or invalid in this context.'

I'm certain the connection string for opening the recordset is the problem, however, i've been unable to configure a string that will connect to the remote server..

Below is my code:
Code:
Private Sub Form_Load()

dbGrid.Visible = False
Set conn = New MYSQL_CONNECTION
conn.OpenConnection "url_to_server", "my_user_name", "my_password", "selected_database"
If conn.State = MY_CONN_OPEN Then
    Debug.Print "Connection opened..."
End If
Set rs = conn.Execute("SELECT * FROM ingredient ORDER BY ingredient")
rCount = rs.RecordCount
cCount = rs.FieldCount

'instantiate and assign recordset

Set rowData = New ADODB.Recordset

'loop and create field names, types and lengths in the recordset
Dim fieldType As DataTypeEnum
For index = 0 To cCount - 1
    fieldType = rs.Fields(index).MySqlType
    'MySQLType VARCHAR is not compatible so change to one that is
        If fieldType = 253 Then
        fieldType = 200
        End If
    rowData.Fields.Append rs.Fields(index).Name, fieldType, rs.Fields(index).Length
Next

'Next we --> Open recordset then loop and add rows to the RecordSet
'simultaneoulsy populating each cell

rowData.Open '<<<< ------ ERROR!!


For counter = 0 To rCount - 1
rowData.AddNew
    For index = 0 To cCount - 1
        rowData.Fields(index).Value = rs.Fields(index).Value
    Next
    rs.MoveNext
Next


'The recordset is now populated. Assign RecordSet to the DataGrid.DataSource property
Set dbGrid.DataSource = rowData

rowData.MoveFirst
previousColumn = dbGrid.Col
previousRow = dbGrid.Row


'Manually close the ResultSet to avoid the known VBMyQL driver memory leak

rs.CloseRecordset
conn.CloseConnection
dbGrid.Visible = True

End Sub