We have a legacy ASP Classic web application hosted on Windows Server 2003 in IIS that connects to our database server, which is AS / 400 . We just upgraded our database server from v5r4m0 to v6r1m0, so we installed the update on our web server to connect to the new database server and change the entire connection string to the corresponding database server.
We have this code on our ASP Classic website:
set objConn2 = server.CreateObject("ADODB.Connection")
objConn2.open connStringGlobal
objConn2.BeginTrans
if rsCheck.eof then
objConn2.execute(InsertQuery)
objConn2.execute(InsertQueryRCDREF)
objConn2.execute(UpdateQuery)
end if
objConn2.CommitTrans
if err.number <> 0 then
session("errMsg") = "An error occured while processing your request. Please try again. <br><br>[Error Description : " & err.Description & "]<br><br>" & InsertQuery & "<br><br>" & UpdateQuery & "<br><br>" & InsertQueryRCDREF
objConn2.RollBackTrans
objConn2.close
set objConn2 = nothing
response.Redirect(request.ServerVariables("HTTP_REFERER"))
else
objConn2.close
set objConn2 = nothing
response.Redirect("default.asp?p=pending")
end if
But it throws an error in a line objConn2.BeginTransthat:
CWBZZ5008 Security error when trying to connect to the system
, , objConn2.execute, , .
:
. , - , . , .
, , ASP Classic, , , .