Solved

msxml4.dll error '80020005' Type mismatch

Posted on 2003-11-03
5
517 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 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