Solved

msxml4.dll error '80020005' Type mismatch

Posted on 2003-11-03
5
513 Views
Last Modified: 2007-12-19
Hi!

I have an asp page with the following statements:

Dim ipAddress

Call oXslProc.addParameter("ipAddress", Server.Variables("REMOTE_HOST"))

I an xsl page with the following statements:
 <xsl:param name="ipAddress"/>

          Requesting IP Address: <xsl:value-of select="$ipAddress"/>&#160; Requested by: <xsl:value-of select="$username"/>


I am getting the following error:
msxml4.dll error '80020005'
Type mismatch.

Any ideas?

Chuck
0
Comment
Question by:TrueBlue
  • 2
  • 2
5 Comments
 
LVL 7

Expert Comment

by:Brad Dobyns, CSM
ID: 9675846
Well, one area where that error occurs is due to a field in your database has a field type different than what you are trying to post. Other things include:

- a string expected, but not enclosed in '
- a double or float not enclosed in '
- an integer enclosed in '
- an '=' operator for string instead of LIKE

Those are just some of the possibilities. Does it give a line where the error occured?

Brad
0
 

Author Comment

by:TrueBlue
ID: 9675882
Hi!

This is the line that it errored out on:

Call oXslProc.addParameter("ipAddress", Server.Variables("REMOTE_HOST"))

Chuck
0
 
LVL 8

Accepted Solution

by:
fozylet earned 200 total points
ID: 9675986
Try this
 Call oXslProc.addParameter("ipAddress", CStr(Server.Variables("REMOTE_HOST")))
0
 

Author Comment

by:TrueBlue
ID: 9676290
Hi fozylet!

Your suggestion got me very close.

Here is the answer.

Without the request if gives a not supported by object error.

Call oXslProc.addParameter("ipAddress", CStr(Request.ServerVariables("REMOTE_HOST")))

Thank you for the help.

Chuck
0
 
LVL 8

Expert Comment

by:fozylet
ID: 9676917
Oops, I didn't see the function part!
Thanks for the points :)
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question