#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jun 2004
    Posts
    1
    Rep Power
    0

    Return value from SQLSERVER 2000


    I am inserting a new row into a table using a stored procedure and I am getting a return value( Identity field). It worked fine with SQLSERVER 97. when I upgraded to SQLSERVER 2000 it was generating
    <LI>Error Type:
    ADODB.Command (0x800A0CC1)
    Item cannot be found in the collection corresponding to the requested name or ordinal.
    /www_test/test.asp, line 56
    Please help me
  2. #2
  3. Unholy Moderator
    ASP Mastermind (5000+ posts)

    Join Date
    Oct 2003
    Location
    In hell, where did you think?
    Posts
    12,026
    Rep Power
    662
    post the code on line 56

Similar Threads

  1. HELP! ADO won't return my stored procedure's return values
    By Steve Schofield in forum SQL Development
    Replies: 4
    Last Post: August 20th, 2007, 05:02 AM
  2. ASP not getting return value
    By DarkRodro in forum Microsoft SQL Server
    Replies: 2
    Last Post: May 4th, 2004, 11:18 AM
  3. Sql Server 2000, Access 2000, Instr() problems
    By mrbuggly in forum ASP Development
    Replies: 2
    Last Post: April 27th, 2004, 02:26 PM
  4. Enabling ASP support on Windows 2000
    By Steve Schofield in forum ASP Development
    Replies: 1
    Last Post: March 28th, 2002, 10:21 AM
  5. HELP! ADO won't return my stored procedure's return values
    By Steve Schofield in forum ASP Development
    Replies: 0
    Last Post: May 12th, 2000, 09:21 PM

IMN logo majestic logo threadwatch logo seochat tools logo