IBM Computer, Laptops and Servers

Back Homepage Content Directory Resource Guide Blog

Why do I get 80020005 errors?

There are several variations of the 80020005 error. Here are a few of them:
Server object error 'ASP 0193 : 80020005' (or 'ASP 0193 : 80020009')
OnStartPage Failed
/<file>.asp, line <line>
An error occurred in the OnStartPage method of an external object.

This is typically an error coming from a custom COM object / component. One way around it is to re-write the object using ObjectContext, instead of onStartPage / onEndPage (which are deprecated as of the release of Windows 2000).
Provider error '80020005'
Type mismatch.

This can happen if you try to set a date column to a value that is not in proper date format, e.g. "UPDATE tableName SET dateColumn='31/31/2002'"... it can also happen when using a command object and named constants (e.g. adDate and adLongVarChar); I will always recommend using a straight EXEC statement against a connection object, rather than go through the hassle and rigorous code required by an ADODB.Command object.
Response object error 'ASP 0106 : 80020005'
Type Mismatch
/<file>.asp, line <line>
An unhandled data type was encountered.

This can happen if you try to response.write an array, or data coming out of a blob / ole / image column, or response.binarywrite non-binary data. To get around the blob scenario, you can upgrade to the latest MDAC (MDAC Download Page), which allows you to avoid the GetChunk / AppendChunk methods. See KB #258038 for (admittedly VB-based) samples of avoiding GetChunk and AppendChunk, and KB #276488 for sample code using ADODB.Stream to send binary data to the browser...

Laptop Battery Another scenario is using a COM object to response.binarywrite large image data. For example, I've seen errors with ASPImage when a JPG file was over 575kb (though I don't know why an image that big would ever be on the web, much less in JPG format at all). One workaround would be to use a different object (maybe ADODB.Stream) to output the file; another would be to use smaller files.

Computer memory is the quickest, cheapest, and easiest way to improve the performance of your system. Find RAM memory upgrades for desktops, laptops, servers, and printers all backed by a lifetime warranty and guaranteed compatible with your computer. Shipping is an everyday low price of $1.99! Computer Memory Outlet sells memory compatible with all leading computer manufacturers like Dell, Apple, Compaq, HP, Sony, IBM, Lenovo, and many more.”

Thinkpad Finally, see Article #2099 if neither of the above situations applies to you.

You searched for information on battery and laptop computer. Your new compaq laptop battery comes in a discharged condition and must be charged before use (refer to your computer manual for charging instructions). Of course, once you decide on the laptop computer battery you need, you will want to receive it right away. Plug battery pack into DC input of your laptop computer which is located in backside of laptop usually. Toshiba laptop battery laptop batteries, laptop battery, toshiba laptop battery, batteries for laptop computer.

[ Comment, Edit or Article Submission ]

Share this:

Add To Yahoo MyWeb Add To Google Bookmarks Add To Furl Fav This With Technorati Add To Newsvine Add To Bloglines Add To Ask Add To Windows Live Add To Slashdot Stumble This Digg This Add To Del.icio.us Add To Reddit

More about:

Nov December 2008 Jan
Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      

IBM Computer, Laptops and Servers Blog on Technorati Related Blog of IBM Computer, Laptops and Servers on Sphere
Content Directory
Resource Guide


PCIQ Computer Repair and IT Support for PC and Mac

Website Links
IBM Computer, Laptops and Servers Copyright © 2008 www.ibmfans.com. All rights reserved. Site Map
Homepage | Blog | Advertise | Privacy Policy | Disclaimer | Contact Us | Links