Classic ASP Discussion - Provider error �80020005�

Print Page | Close Window

Provider error �80020005�

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6051
Printed Date: 31 March 2026 at 1:36am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Provider error �80020005�

Posted By: markstramaglia
Subject: Provider error �80020005�
Date Posted: 29 September 2003 at 8:55pm

Howdy,

I have an Access database hosted on uplinkearth, and an ASP page that accepts data from a form on an html page. When I hit submit, I get this:

Provider error '80020005'

Type mismatch.

/clientinput.asp, line 20

Line 20 of my code is:

rsAddRecord.Open strSQL, "Client", adoCon

If anybody has any ideas of what this might be, I'd appreciate the help. All of my data fields are specified as text, so its not what I thought it might be. I'm stuck.

Thanks for the help! If anybody wants the file, its http://www.angelcaregiving.com/asclientreg.html - www.angelcaregiving.com/asclientreg.html and the ASP file is http://www.angelcaregiving.com/clientinput.asp - www.angelcaregiving.com/clientinput.asp

Replies:

Posted By: fernan82
Date Posted: 29 September 2003 at 9:49pm

You might want to zip the asp file if you want anyone to see it...

Posted By: Mahesh
Date Posted: 03 October 2003 at 10:03am

rsAddRecord.Open strSQL, "Client", adoCon

I don't understand the "Client" bit. To open a recordset all you need is 2 properties, the SQL statement and the active DB connection.

Try rsAddRecord.Open strSQL,adoCon and see if it works.