Post reply

ADODB.Recordset error ''800a0cc1'' .Item cannot be found in the collection.

  • February 14, 2007 at 10:07 pm

    #122982

    Hi all,

    I am getting the below error while pulling a report for analysis service.

    Can any one explain what is the problem and where have to concentrate?

    ADODB.Recordset error '800a0cc1'

    Item cannot be found in the collection corresponding to the requested name or ordinal.

    Any help would be appreciated..:-)

    Thanks,

    Bagath

  • February 15, 2007 at 4:39 am

    #689900

    somewhere in the report, it is referencing a column that does not exist in the SQL statement returned into the recordset. a valid  recordset was returned, and has rows, otherwise you get a different error.

    things to look for:

    the column is mispelled in the report. ie rs("FristName").value instead of rs("FirstName"),value

    the SQL has 5 columns or something, but the report assumes a different 6th column was included. SELECT FIRSTNAME,LASTNAME FROM SOMETABLE, but the report references rs("MiddleName").value

    A column was not aliased, ie SELECT SUM(INVOICEAMT) FROM SOMETABLE should be SUM(INVOICEAMT) AS INVOICEAMT

    HTH

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 15, 2007 at 4:48 am

    #689901

    Thanks allot for the response....

    Yes you right.The problem was with the cubes(cubes were not exist) only.

    Thanks once again.

    Bagath.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply