Web Wiz Forums - line 82 in functions_date_time

line 82 in functions_date_time_format.asp

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15551
Printed Date: 13 April 2026 at 7:10am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: line 82 in functions_date_time_format.asp

Posted By: snooper
Subject: line 82 in functions_date_time_format.asp
Date Posted: 22 June 2005 at 7:00pm

Hi all

i am using the latest version on SQL.

today, for the 2nd time, i am suddenly getting the following error:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/lishka/functions/functions_date_time_format.asp, line 82

its important to stress, that i have not made ANY changes in the coding or DB at all in this time.

last time it happened, the host (jodo) was kind enough to restore a DB from a few hrs back and it seemed to solve the issue, whatever it may have been.

today, it happened again, and stephen isnt in to help out like last time, so it may b a little longer.... anyway... i want to get to the root issue.

anyone got any idea what this could be?

line 82 is marked:

'Craete a recordset to get the date and time format data
Set rsDateTimeFormat = Server.CreateObject("ADODB.Recordset")

'Initalise the strSQL variable with an SQL statement to query the database
If strDatabaseType = "SQLServer" Then
  strSQL = "EXECUTE " & strDbProc & "TimeAndDateSettings"
Else
  strSQL = "SELECT " & strDbTable & "DateTimeFormat.* FROM " & strDbTable & "DateTimeFormat;"
End If

'Query the database

'***NEXT LINE IS 82****
rsDateTimeFormat.Open strSQL, adoCon

'If there are records returned then enter the data returned into an array
If NOT rsDateTimeFormat.EOF Then

  'Redimension the array
  'This is done as a dynamic array oterwise it can't be filled by the application array next time around
  ReDim saryDateTimeData(17)

'....

any ideas?

thanks!

Replies:

Posted By: dpyers
Date Posted: 23 June 2005 at 2:06am

It's looking for an integer constant and not finding one where it expects to for the particular operation.
You'd need to response.write strSQL, adoVon, and also check the stored proc.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: snooper
Date Posted: 23 June 2005 at 5:46am

i understand.

here's another weird thing about it: a few minutes later, it all came back, and was fine - without me or the host changing anything - AT ALL.

i looked up the error, and it seems it may have something to do with a session issue, and support made a similar commenty, but they couldnt check it out properly, because it started working again. see here: http://support.microsoft.com/kb/q197323 - http://support.microsoft.com/kb/q197323

this is on Win6, by the way, on Jodo.

all other comments welcome!