This problem is generally not a big mistake. You can refer to the following steps to solve it. First you need to determine the cause of the error:
Let IE display detailed error information:
Menu--Tools--Internet Options--Advanced--Show friendly HTTP error messages, remove this option, it will be very helpful to help you determine the error!
Common causes of 500 errors include: ASP syntax errors, ACCESS database connection statement errors, file reference and include path errors, and the use of components that are not supported by the server such as FSO.
Pay attention to some release operations of the database. Are they used?
set rs=nothing instead of rs=nothing and other issues