Provider error ’80020005’
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12403
Printed Date: 13 April 2026 at 9:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Provider error ’80020005’
Posted By: lydbury
Subject: Provider error ’80020005’
Date Posted: 01 November 2004 at 1:41pm
|
Any ideas please people - I have searched the forum and found no answer. This just happens when new people try to log in. Duncan Provider error '80020005' Type mismatch. /forum/register.asp, line 901 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 02 November 2004 at 5:15am
|
Could be a corrupted file, try reuploading the files again. If that fails, try updating the servers MDAC drivers from www.microsoft.com, if you have access to the sweb server. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: lydbury
Date Posted: 02 November 2004 at 9:14am
|
Still can't solve this one - I had forgotten about it but we got a new user! All is well for existing users but this crops up when a new user tries to register. Duncan |
Posted By: javi712
Date Posted: 10 August 2005 at 12:53pm
|
Hello everyone.
I'm having the exact same problem. Has anyone found a solution to this? Thanks in advance! |
Posted By: dpyers
Date Posted: 10 August 2005 at 1:48pm
|
This is an old thread, but if the re-upload or mdac solutions didn't work for you, search aspfaq.com for 80020005 If you have added mods, you might get this type of error because of two mods on a page using the same variable name for different things. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: lydbury
Date Posted: 10 August 2005 at 1:58pm
|
I had forgotten about this. Thank the Lord, I have not had the problem
again. I am not sure how I solved it (nearly a year ago) but I suppose
it was just to upload everything again. Good luck Duncan |
Posted By: JJLatWebWiz
Date Posted: 10 August 2005 at 4:43pm
|
I think there is a good chance that the Access MDB is corrupt. A simple MS Access Compact & Repair might do the trick.
That error code indicates a type mismatch between what is being sent to the database and the actual field type. Line 901 in version 7.92 is:
.Fields("Location") = strLocation
The Author.Location field in the Access is Text(60) and in the SQL version is nvarchar(60). Both allow null's and aren't indexed, so basically, the field should allow absolutely any character or no text at all.
What version of the WWF are you running and is it Access or SQL? Does the data for a new user actually get stored? If so, can they change the data after they've registered?
|
Posted By: javi712
Date Posted: 10 August 2005 at 6:48pm
|
Thanks to all for your prompt response!
I tried each and everyone of your suggestions and the one that did it for me was changing the author.location field in the access database. It was set to number and not text. Thanks to all of your again! |
Posted By: javi712
Date Posted: 10 August 2005 at 7:15pm
|
Hi everyone, I'm having now another problem that I don't know if its related to this or not.. but for some reason now I can edit other member's posts, it takes me to the insufficent permissions page. Any idea why this is happening?
Thanks again! |
Posted By: dj air
Date Posted: 10 August 2005 at 7:19pm
|
there is a security risk within V7 and for a quick fix i belive editing of posts is disabled. im not to sure on the situation but if you search within this forum you will find the topic that boRg says about it |
Posted By: javi712
Date Posted: 11 August 2005 at 9:34am
| Its interesting thoug because before I was perfectly able to edit other member's post which is natural considering I am the admin. But I'll do a search and see what comes up, thanks dj air! |