Problem with ASP & MySql

HI ,
I have mysql driver . i cant setting DSN because my hosting provider dosent support.

so i try to set dsn-less and its make me a problem with recordset

my code look like this:
set con=server.CreateObject("adodb.connection")
con.Open "driver={MySQL Driver}; server=myserver;uid=myuid;pwd=*******;database=*** *****;"
rs.Open "test",con,3,3
rs.AddNew
rs.Fields ("id") =Request("text1")
rs.Fields ("name") =Request("text2")
rs.Update
rs.Close
set rs=nothing
con.Close
set con=nothing

and i get this message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

Please Help!!
Yossi.

Try this:

Dim con, SQL

Set con = Server.CreateObject("ADODB.Connection")
con.Open "driver={MySQL Driver}; server=myserver;uid=myuid;pwd=*******;database=***
*****;"
SQL = "INSERT INTO test (id, name) VALUES ('" & Request("text1") & "','" & Request("text2") & "')"
con.Execute(SQL)

con.Close
Set con = Nothing
Set SQL = Nothing