I tried your suggestion and this is the error I receive:

   Microsoft JScript runtime error '800a01b6'

   Object doesn't support this property or method

   /nafpinc/_admin/employment-act.asp, line 9

that's because the recordset object doesn't support the execute method. You need a connection object instead, but then you will also need to assign the connection string using the Open method instead of the ActiveConnection property.

something like the following .. i guess

dim objConn
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open= ... 'your file & file
objConn.execute yourSqlStatement

btw, the above is vbscript but jscript

I got it working. Thanks everyone for all your help.