How can I correctly connect two mysql SQL statements in asp?

Database mysqlsqlstr output updatemacsetmac_del-1wheremac_id & #39; 40877 & #39; insertintoMACeditedselect *, now (), & #39; hidden device & #39; fromMACwheremac_id & #39; 40877 & #39; error Microso mysqlasp

Mysql database
<%

Dim sqlstr, rs, sqlstr1

Set rs = Server. CreateObject ("ADODB. Recordset ")
Sqlstr = "update mac set mac_del =-1 where mac_id = '" & id &"';"
Sqlstr = sqlstr & "insert into MACedited select *, now (), 'hide device' from MAC where mac_id = '" & id &"';"
Response. write sqlstr

Rs. open sqlstr, conn, 1, 3
Response. Redirect (request. ServerVariables ("HTTP_REFERER "))

%>

Sqlstr output
Update mac set mac_del =-1 where mac_id = '20160301'; insert into MACedited select *, now (), 'hide device' from MAC where mac_id = '20160301 ';

Error

Microsoft ole db Provider for ODBC Drivers error '80040e21'

ODBC drivers do not support the required attributes.
After modifying the code
<%
Dim sqlstr, rs, sqlstr1

Set rs = Server. CreateObject ("ADODB. Recordset ")

Sqlstr = "update mac set mac_del =-1 where mac_id = '" & id &"';"
Sqlstr1 = "insert into MACedited select *, now (), 'hide device' from MAC where mac_id = '" & id &"';"
'Sqlstr = sqlstr & "insert into MACedited select *, now (), 'hide device' from MAC where mac_id = '" & id &"';"
Response. write sqlstr

Rs. open sqlstr, conn, 1, 3
Rs. open sqlstr1, conn, 1, 3
Response. Redirect (request. ServerVariables ("HTTP_REFERER "))
%>
Operation successful.