Solved

msxml4.dll error '80020005' Type mismatch

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

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 informatio…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 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