Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Provider error ’80020005’
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Provider error ’80020005’
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
lydbury View Drop Down
Groupie
Groupie


Joined: 12 January 2004
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lydbury Quote  Post ReplyReply Direct Link To This Post Topic: Provider error ’80020005’
    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

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
lydbury View Drop Down
Groupie
Groupie


Joined: 12 January 2004
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lydbury Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
javi712 View Drop Down
Senior Member
Senior Member


Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488 		Post Options Post Options   Thanks (0) Thanks(0)   Quote javi712 Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
lydbury View Drop Down
Groupie
Groupie


Joined: 12 January 2004
Status: Offline
Points: 44 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lydbury Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
JJLatWebWiz View Drop Down
Groupie
Groupie
Avatar

Joined: 02 March 2005
Location: United States
Status: Offline
Points: 136 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JJLatWebWiz Quote  Post ReplyReply Direct Link To This Post 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?
 
Back to Top
javi712 View Drop Down
Senior Member
Senior Member


Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488 		Post Options Post Options   Thanks (0) Thanks(0)   Quote javi712 Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.