DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: ADO Error on Open

  1. #1
    Joe Maki Guest

    ADO Error on Open


    ADO 2.5 against SQL Server 6.5

    I've been getting an occasional error I can't find an explanation for:

    Err.Number = -2147217900

    Err.Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Cursor open
    failed because the size of the keyset row exceeded maximum allowed row size.

    The SQL statement I'm passing to the open method is 1404 in length. Is that
    the problem? Any suggestions would be appreciated.

    ...Joe Maki
    jmaki@customerlinkone.com



  2. #2
    Dan Pollak Guest

    Re: ADO Error on Open

    Hi Joe,

    What is the record length of the resulting cursor? The following information
    comes from article Q223758 in the MSKB:

    "The total number of bytes allocated for all product attributes exceeds the
    maximum number of bytes per row that SQL Server allows. SQL Server 6.5
    allows a
    maximum row size of 1962 bytes and SQL Server 7.0 allows a maximum row size
    of
    8060 bytes."

    HTH, Dan


    "Joe Maki" <jmaki@customerlinkone.com> wrote in message
    news:39182e22$1@news.devx.com...
    >
    > ADO 2.5 against SQL Server 6.5
    >
    > I've been getting an occasional error I can't find an explanation for:
    >
    > Err.Number = -2147217900
    >
    > Err.Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Cursor

    open
    > failed because the size of the keyset row exceeded maximum allowed row

    size.
    >
    > The SQL statement I'm passing to the open method is 1404 in length. Is

    that
    > the problem? Any suggestions would be appreciated.
    >
    > ...Joe Maki
    > jmaki@customerlinkone.com
    >
    >




  3. #3
    Joe Maki Guest

    Re: ADO Error on Open


    "Dan Pollak" <dpollak@email.msn.com> wrote:
    >Hi Joe,
    >
    >What is the record length of the resulting cursor? The following information
    >comes from article Q223758 in the MSKB:
    >
    >"The total number of bytes allocated for all product attributes exceeds

    the
    >maximum number of bytes per row that SQL Server allows. SQL Server 6.5
    >allows a
    >maximum row size of 1962 bytes and SQL Server 7.0 allows a maximum row size
    >of
    >8060 bytes."
    >
    >HTH, Dan
    >


    I thought this might be the problem, I couldn't find the limitation spec
    for row size. What confuses me is if I extract the select statement I'm using
    and run it from SQL's Enterprise Managers query window it runs just fine.
    I thought it might be a limitation of the ado provider.
    ...joe


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center