KB Issue
There are different variants of this code. We will list them all here as they become available.
Sometimes the error is caused by misnaming your Parameter.
Issue Details
You may receive this error if you run your script with a misnamed parameter.
ADODB.Parameters error '800a0e7c'
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
Script.asp, line 10
Recreate Issue
To recreate this issue, misname your parameters.
Change adInteger
Copy
Search Site
Search Google
to adVarChar
Copy
Search Site
Search Google

(or)
Vise-Versa
This will also happen if you misspell the parameters name: Intger
Copy
Search Site
Search Google
should be Integer
Copy
Search Site
Search Google
Resolve Issue
Examples of the different types of Parameter errors.
Example#1:
We are querying an ID (MemID) of DataType Integer
Copy
Search Site
Search Google
Code Example 
sqlMyGalCount.Parameters.Append sqlMyGalCount.CreateParameter("@MemID", adVarChar,adParamInput, , sqlID)
As you can see above, we have set its data type as adVarChar
Copy
Search Site
Search Google
, thus causing the error.
To fix this, change adVarChar
Copy
Search Site
Search Google
to adInteger
Copy
Search Site
Search Google
Code Example 
sqlMyGalCount.Parameters.Append sqlMyGalCount.CreateParameter("@MemID", adInteger,adParamInput, , sqlID)
Example #2:
If you are using a Field of DataType = VarChar
Copy
Search Site
Search Google
Code Example 
NewAssoc.Parameters.Append NewAssoc.CreateParameter("@SPPass", adVarChar, adParamInput,, SPID)
As you can tell, you are missing the Field Length.
Code Example 
NewAssoc.Parameters.Append NewAssoc.CreateParameter("@SPPass", adVarChar, adParamInput, 25, SPID)
Example #3:
If you are using a Field of DataType = DateTime
Copy
Search Site
Search Google
Code Example 
sqlUpdate.Parameters.Append sqlUpdate.CreateParameter("@RevDate", adDatetime, adParamInput, ,date())
Try changing the adDateTime
Copy
Search Site
Search Google
to adVarChar
Copy
Search Site
Search Google
.
Make sure that within your Table Column, you do not have a default value of (getdate())
Copy
Search Site
Search Google

This will cause another error.
Code Example 
sqlUpdate.Parameters.Append sqlUpdate.CreateParameter("@RevDate", adVarChar, adParamInput, 25,date())
Example #4:
If you misspell the parameter's name, you will also get this error.
So if we have:
Code Example 
sqlUpdate.Parameters.Append sqlUpdate.CreateParameter("@MyID", adIntger, adParamInput, ,getMyID)
In the above, we have misspelled the Parameter Name adIntger
Copy
Search Site
Search Google
Code Example 
sqlUpdate.Parameters.Append sqlUpdate.CreateParameter("@MyID", adInteger, adParamInput, ,getMyID)
The above is spelled correctly.
This will allow for the insert to happen.