I am trying to manipulate a MySql database on a webserver (now localhost). I used the folowing code:

Dim Omgeving as rdoEnvironment
Dim conn as rdoConnection
Dim rs as rdoResultset
set Omgeving = rdoEnvironments(0)
set conn = Omgeving.OpenConnection("myodbc", 1, false, "uid=gebruikersnaam";pwd=")

To view data I define a query: strQuery and I acces the database with:
set rs = conn.OpenResultset(strQuery)

When using a string containing select or update query everthing works fine, but when I use an insert query, the statement is executed without errors but also without the addition of the record.
Executing the query in the Mysql command line client works fine.

What's the trouble or am I using the wrong technique?
I hope to find here some advice
Thx in advance