Parameter Limitation in ADO.NET


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Parameter Limitation in ADO.NET

  1. #1
    John Hauppa Guest

    Parameter Limitation in ADO.NET


    Hello,

    I was wondering if anyone knows if there is still a limitation on the number
    of parameters you can use in a parameters collection with ADO.NET. I know
    in ADO 2.6 there was a maximum of 1024 parameters per command.

    Sometimes I reach this limitation when sending large batches of parameterize
    SQL to the database. Does anyone know if there is still a limit? I could
    not find any information about it in the docs or in my books.

    Thanks,
    John

  2. #2
    Jay B. Harlow Guest

    Re: Parameter Limitation in ADO.NET

    John,
    Hmm...

    There is a 1024 parameter limitation to SQL Server Stored procedures. This
    would be true whether its ADO 2.6 or ADO.NET...

    Are you using another RDMS that actually supports more than 1024 parameters?

    Hope this helps
    Jay

    "John Hauppa" <hauppaj@modularis.com> wrote in message
    news:3c5feb51$1@10.1.10.29...
    >
    > Hello,
    >
    > I was wondering if anyone knows if there is still a limitation on the

    number
    > of parameters you can use in a parameters collection with ADO.NET. I know
    > in ADO 2.6 there was a maximum of 1024 parameters per command.
    >
    > Sometimes I reach this limitation when sending large batches of

    parameterize
    > SQL to the database. Does anyone know if there is still a limit? I could
    > not find any information about it in the docs or in my books.
    >
    > Thanks,
    > John




  3. #3
    sanjay Guest

    Re: Parameter Limitation in ADO.NET


    Hello John
    Can you please help out in finding the limit for parameter in AD0 2.1 and
    2.0 lib Command Object


    "John Hauppa" <hauppaj@modularis.com> wrote:
    >
    >Hello,
    >
    >I was wondering if anyone knows if there is still a limitation on the number
    >of parameters you can use in a parameters collection with ADO.NET. I know
    >in ADO 2.6 there was a maximum of 1024 parameters per command.
    >
    >Sometimes I reach this limitation when sending large batches of parameterize
    >SQL to the database. Does anyone know if there is still a limit? I could
    >not find any information about it in the docs or in my books.
    >
    >Thanks,
    >John



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