Hi,
Problem with global.asa not firing 100% of the time. This error crops
up several times throughout the day but if you wait a while and reload
the page (could be 5 mins or an hour) it will suddenly start working
again.
The error is:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/footer.asp, line 101
Line 101 in the footer.asp file reads:
InnovationRS.Open sql, Application("AnymousConnection")
I believe that bad code would produce a persistent error message. The
application would either work, or generate an error 100% of the time,
not be intermittent. The error is now appearing 3 or 4 times a day with
different users reporting it, but like I said, if you wait a while and
refresh the page, it is working again.
I had one guy tell me that the "Driver={SQL Server};...." connection
string is not good for SQL, but I have seen it used all over the place,
and again, why would it work intermittently. It either connects to the
DB or not.
Does anyone know the cause of the global.asa being read intermittently.
The guys at the datacenter say its a coding issue, but I can find no
problem with the code. Any information or knowledge would be helpful,
and greatly appreciated.
Here is my global.asa contents.
Code:
--------------------
SCRIPT LANGUAGE=VBScript RUNAT=Server
Sub Application_OnStart
''''''''''''''''''''''''''''''''''
'''''''DATABASE SECTION'''''''''''
'Database connection string
Application("AnymousConnection") = "Driver={SQL Server}; Server=mssql.megasqlservers.com; Database=mssql_anymous_com; UID=dbm.anymous.com; PWD=badulla"
''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''
'''''''PATHS SECTION''''''''''''''
'Secure site URL
Application("SecureSiteURL") = "https://www.anymous.com"
''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''
'''''''EMAIL SECTION''''''''''''''
'Support Email
Application("SupportEmail") = "an*****@anymous.com"
'Support VIHN Email
Application("SupportVIHNEmail") = "an*****@anymous.com"
'Webmaster Email
Application("WebMasterEmail") = "we*******@anymous.com"
'Technical Service Email
Application("TechServEmail") = "te******@anymous.com"
'Administrative Email
Application("AdminEmail") = "an*****@anymous.com"
'Anymous.com email
Application("AnymousCom") = "an*****@anymous.com"
''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''
'''''''MISC SECTION'''''''''''''''
'Support Name
Application("SupportName") = "Anymous Laboratories"
''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''
'''''''PASSWORDS SECTION''''''''''
'Password for US prices
Application("A") = "123456"
'Password for English prices
Application("B") = "7891011"
'Password for German prices
Application("C") = "12131415"
''''''''''''''''''''''''''''''''''
End Sub
Sub Session_OnStart
'Session_OnStart body should go here
End Sub
Sub Session_OnEnd
'Session_OnEnd body should go here
End Sub
/SCRIPT
--------------------
--
bloodhound
------------------------------------------------------------------------
Posted via
http://www.codecomments.com
------------------------------------------------------------------------