You are running an insert query and therefore do not need a recordset object, these are used when getting records out of a db.
You need to create a connection object and then use the Execute() method of that.
Something like the following should work...
var conn = Server.CreateObject("ADODB.Connection");
var strsql ="INSERT INTO members (DateAdd,JobTitle,JobDescription) VALUES ('7/1/2005','Test','test');";
Like mkayombo says, you may need to surround the date with hash signs, but this is only applicable to some databases e.g. Access