vb6-Runtime error

[101]

Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.

[hariharanmca]

Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.

which Database MS Access or Sql Server

[hariharanmca]

Tell me what's wrong in the statement
recordset.open "select name from tablename where birthdate=4/3/2007",con
runtime error as :no value is given to 1 or more parameters required.

Change the QRY like

"select name from tablename where birthdate= '4/3/2007' "

this