Hello . I am still trying to connect to a mysql data base but it don´t works what is wrong?:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim SQL As String
Dim str As String
Set rs = New ADODB.Recordset
Set cmd = New ADODB.Command
Set conn = New ADODB.Connection
'I want to connect to mysql
'Do I need the data source?
' I want to insert a value (variavel) into a field called (indicador)
variavel = "insert into atv(INDICADOR)values("hdhduduh")"
rs.Open str, conn, adOpenDynamic, adLockOptimistic