472,109 Members | 1,833 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,109 software developers and data experts.

Microsoft VBScript runtime error '800a0006'

My asp webpage was working well in the past 5 years. Recently it shows the message:

Microsoft VBScript runtime error '800a0006'
Overflow: 'addOrder'

The source code is as follow:
Expand|Select|Wrap|Line Numbers
  1.     'insert data into database
  3.     dim objCart
  4.     dim objOrder 
  6.     set objCart = createobject("EStore.ShopCart")
  7.     set objOrder = createobject("EStore.Order")
  9.     ret = objOrder.addOrder(cart_id,bname,request("firstname"), _
  10.                             bemail,baddr,bcity,bstate,bcountry, _
  11.                             bzip,request("contactoffice"),bphone, _
  12.                             request("contactmobile"),request("pager"), _
  13.                             request("fax"),saddr,scity,sstate,scountry, _
  14.                             szip,sphone,delTime,delivery,ctype,cname,cno,_
  15.                             cexpire,date(),sname,request("delfirstname"))
Anyone can help me? Many thanks.

Oct 9 '07 #1
3 8030
3,406 Expert 2GB
I hoped someone else would answer you, I'm not familiar with the estore object and I didn't want to steer you completely wrong. Is this something you bought and installed on your server? It sounds like it might no longer be supported, either because the files involved were corrupted, or because they were compatible with an older version of your server. Does that make sense?

Oct 11 '07 #2
I've got the same problem.....it seems to be all over the place.....any ideas?? New OS patch?? Due to an upgrage?? I'm screwed!
Oct 15 '07 #3
346 Expert 100+
I don't know anything about e-store either. Frankly though, i doubt it's the object itself unless you recently reinstalled it or download a new version before this started happening. It could be corrupt, but you could rule that out by downloading the latest version, or just re-installing the current version if you still have the installer.

In any case, an overflow is usually generated when something "overflows" - for instance if you were to wrap CInt() around 875765764654656457656745 - it would give an overflow error because the number is way out of range for the CInt() function. Or if you tried to insert 3000 ascii characters into an nvarchar(63) data column in your database, it would throw a stack overflow, etc.

It's best to take it back to basics, have you tried just doing a simple one column update? I would create a new table with 2 columns, an auto-increment, and an nvarchar(15). Then a simple ASP page to test insertion into this table to see if the error occurrs under controlled circumstances.

Expand|Select|Wrap|Line Numbers
  1. ret = objOrder.addOrder("Does it work?")
Then, if that doesn't throw the error, I would stress test it by throwing it inside of a loop, and logging the amount of times it throws an error.

Expand|Select|Wrap|Line Numbers
  1. On Error Resume Next
  2. For i=1 To 100
  3.    ret = objOrder.addOrder("Does it work?")
  4.    If err.Number <> 0 Then
  5.       'create a text file if this is the first occurrance.
  6.       'open the text file if this is not the first occurrance.
  7.       'keep a tally on the total amount of failures
  8.       Err.Clear
  9.    End If
  10. Next
This should at least identify whether it is the object itself throwing the error or not.

If all else fails, you could also contact the support team and ask them what is going on.

This seems to be the company that produces it... http://www.oneworldstorefront.com/default.asp

Hope this gets you to your answer!

Oct 15 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by =?Utf-8?B?TWF0dCBDYWxob29u?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.