Solved

msxml4.dll error '80020005' Type mismatch

Posted on 2003-11-03
5
515 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Classic ASP application Will support SQL 2014 5 94
Downside of adding characters set in ASP pages 6 29
Index on a Table 6 25
Diminish Pop-up  in 3 seconds 7 49
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…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 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