Parameter Limitation in ADO.NET

[John Hauppa]

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

[Jay B. Harlow]

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

[sanjay]

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