SQL Server /VBScript Problem

[ranth]

I am receiving a VERY strange error of the type Overflow.

This is not math related whatsoever.

When I need to make several updates/inserts to a database I am putting each command into an array which then loops through and executes the commands under the control of a transaction using an ADODB.Connection object.

The problem is that sometimes, randomly, an Overflow error will occur. When I investigate the problematic sql command it will run no problem whatsoever. When I try to run the series of commands again they will execute without problem.

The database fields are of adequate size to accept the values being put into them.

I am using SQL Server 2000 backend with IIS 6/vbscript.

What other things can cause a vbscript runtime Overflow error? Anything related to the ADODB.Connection object? or perhaps arrays?

[aspdaddy]

Arrays can if they are large, use a dictionary instead and see if it stops. I have also see it when formatting SQL Money types.