homepage Welcome to WebmasterWorld Guest from 54.226.166.224
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
Provider error '80020005' Type mismatch
Unable to find solution
Staffa




msg:4101744
 2:07 am on Mar 21, 2010 (gmt 0)

I've been hitting a brick wall for the last 14 hrs or so.

Writing a small script in classic ASP to update 3 numbers in a table in MS Access, something I have done umpteen times, however this time I'm stumped.

Updating 3 number fields in a 4 field record, 2 fields would update as expected if it wasn't for the third field throwing an error : Provider error '80020005' Type mismatch.

When I take the third field out of the update the other two update the numbers perfectly.

I have been looking all over the web and while I found questions about this error they only had some roundabout answers but no definite solution.

If anyone here knows, please share, many thanks in advance.

 

bmcgee




msg:4101771
 4:46 am on Mar 21, 2010 (gmt 0)

Your SQL string is probably using a wrong type. For instance if you are updating a string field, you need to wrap the value in ticks. And dates need formatting.

dstiles




msg:4102012
 9:16 pm on Mar 21, 2010 (gmt 0)

Another fault I've come across is the field name being a reserved word - eg Type.

Staffa




msg:4102014
 9:18 pm on Mar 21, 2010 (gmt 0)

Thank you bmcgee, your suggestion would work fine for a VBscript runtime error but this is a different kind of error.

One way or the other I will crack this problem. :)

Staffa




msg:4102208
 9:21 am on Mar 22, 2010 (gmt 0)

Thank you dstiles, that was one of the first things I checked.

In the meantime I've solved it, so it's OK now.

Thanks again.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved