sql = "insert into log(log_datetime,log_ip,log_user,log_companyid,log_thing) values('"&now()&"','"&local_ip&"','"&user&"',"&companyid&",'"&thing&"')"
   conn.execute(sql)

sql server表示时间不用now()，用getDate()

xiexie