ADO execute

When using execute statements
ex: set recordset= connection.execute("Insert into emp (idno, name) values
(" & idno & ", " & name & ") it gives error.
error is "no value is given to one or more parameters".
it accepts numeric value but not string values.
please help me!
[290 byte] By [muthumadhan] at [2007-11-17 13:03:32]