Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Max number of Parameters

Status
Not open for further replies.
riarc

riarc

Programmer
Dec 6, 2001
44
US
Does anybody know the max number of parameters that you can append to a command object. I have a command object with 15 parameters appended to it and when I try to exec, I get a to many param error. The database is SQL server so I know I can have alot more than 15 parameters.
 
Sort by date Sort by votes
I've done 30 or so without a problem.

A SQL Server 7 stored procedure can handle 1024 parameters. You would think that VB/ADO could support what SQL Server could do.

Whether passing 1000 parameters is a good thing is a different story.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
255
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
DOWNLOAD story of extraction of LOTTO 1
Replies
4
Views
456
strongm
strongm
sal21
  • Locked
  • Question
Check if mobile number exists, with Api rest or other service. Possibile? 1
Replies
2
Views
504
sal21
sal21
2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
595
2009luca
2009luca
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
2K
klima
K

Part and Inventory Search

Sponsor

Back
Top