[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1440
  • Last Modified:

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

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
sridharj_ap
Asked:
sridharj_ap
  • 4
  • 3
1 Solution
 
joeposter649Commented:
Try using ...
set myCmd.ActiveConnection = myCon

I assume you have created and opened myCon.
0
 
sridharj_apAuthor Commented:
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
 
joeposter649Commented:
Do you close your connections and set your objects to nothing.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
sridharj_apAuthor Commented:
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
 
sridharj_apAuthor Commented:
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
 
sridharj_apAuthor Commented:
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
 
PashaModCommented:
Closed, 100 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now