Solved

ADODB.Command error '800a0d5d': Application uses a value ...

Posted on 2004-09-07
8
1,431 Views
Last Modified: 2010-08-05
Hi,

I am using a Stored Procedure to insert data into a db. The ASP code is:

Set myCon = Server.CreateObject("DBCon.DBConnect")

      Set MYCmd=Server.createObject("ADODB.Command")
    myCmd.ActiveConnection = myCon.Connect()
    MYCmd.CommandType=adcmdStoredProc
    MYCmd.CommandText="Get_List"

    Set MYParam = MYCmd.CreateParameter("auditid", adinteger, adParamInput, 4)
        MYCmd.Parameters.Append MyParam
        MYCmd.Parameters("prodid")= prodid

    Set MYParam = MYCmd.CreateParameter("Loginid", adinteger, adParamInput, 4)
        MYCmd.Parameters.Append MyParam
        MYCmd.Parameters("Loginid")= loginid

    Set MYRS = MYCmd.Execute

The prodid and the loginid are variables that are supplied to this page from a previous page using querystrings appended to the URL (like page.asp?prodid=<%=productid%> etc).

I am getting the following error on executing the stored proc.

"ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation. "

Any ideas?

Regards
Sridhar
0
Comment
Question by:sridharj_ap
[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
  • 4
  • 3
8 Comments
 
LVL 15

Expert Comment

by:joeposter649
ID: 11996511
Try using ...
set myCmd.ActiveConnection = myCon

I assume you have created and opened myCon.
0
 
LVL 1

Author Comment

by:sridharj_ap
ID: 11996604
Hi,

Thanks for the reply. Actually, this script is running on a production server. I have created an exact copy on a test server and is running fine there also. What I am trying to do is create a page with 3 frames in it and call 3 pages in the 3 frames so that the whole appears to be one single page with different forms.

When I call the framed page only I am getting this error.

Regards
Sridhar
0
 
LVL 15

Expert Comment

by:joeposter649
ID: 11997904
Do you close your connections and set your objects to nothing.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 1

Author Comment

by:sridharj_ap
ID: 12003435
Hi,

Yes, I do. But I was wondering about something (I didn't think of it until I saw your response).

All the 3 pages use the same variables. Previously, when they were separate pages, they were mutually exclusive, i.e., you could call only page at a time. Now, all 3 pages are called simultaneously (remember? They are now in a single frame). Could this be an issue?

Regards
Sridhar
0
 
LVL 1

Author Comment

by:sridharj_ap
ID: 12005299
Hi,

This is not an issue since I changed all the variables, so that they are different in all pages. But still, I am getting an error.

Regards
Sridhar
0
 
LVL 1

Author Comment

by:sridharj_ap
ID: 12023582
Hi,

I found the bug! The query string from the previous page was not populating in this page.

Regards
Sridhar

P.S: As the responses have not pointed to the solution nor have forced me to look in that direction, I am sorry that I cannot allocate any points. So how do I close the query without assigning points?
0
 
LVL 15

Expert Comment

by:joeposter649
ID: 12026531
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 12042483
Closed, 100 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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
CDO.Message not able to send attachement 5 40
Issues with Insert statement 12 31
Reg Exp to extract Url from string asp 12 39
MS SQL and column defined as time 7 26
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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

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