423,834 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,834 IT Pros & Developers. It's quick & easy.

Microsoft VBScript runtime error '800a0006'

P: 6
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
  2.  
  3.     dim objCart
  4.     dim objOrder 
  5.  
  6.     set objCart = createobject("EStore.ShopCart")
  7.     set objOrder = createobject("EStore.Order")
  8.  
  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"))
  16.  
Anyone can help me? Many thanks.

Grace
Oct 9 '07 #1
Share this Question
Share on Google+
3 Replies


jhardman
Expert 2.5K+
P: 3,401
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?

Jared
Oct 11 '07 #2

P: 1
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

markrawlingson
Expert 100+
P: 346
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?")
  2.  
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
  11.  
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!

Sincerely,
Mark
Oct 15 '07 #4

Post your reply

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