The advice below relates to both Server.CreateObject and CreateObject use in vbscript jscript vba The Web Server sections are specific to asp-classic but still worth reading. What Causes This error? Server.CreateObject Failed is caused most commonly when Web Applications are moved from one Web Server to another without an understanding of external COM components that … Read more
Date formatting options are limited in Classic ASP by default, there is a function FormatDateTime() which can format your date is various ways based on the servers regional settings. For more control over date formatting though there are built in date time functions Year(date) – Returns a whole number representing the year. Passing Date() will … Read more
This could be due to not properly closing recordset and connection objects and setting their references to nothing. Make sure this is done every time you use these objects: myRecordset.close myConnection.close set myRecordset = nothing set myConnection = nothing