Is there an upper limit to the number of items in a listbox that ASP can search for?
Posted on 2007-11-28
Our users often need to search a SQL Server table for a large number of 16-digit entries. The ASP front-end that we've created allows the user to cut/paste all the items of interest into a listbox. This approach works well unless the user is searching for a rather large number of items - say 20,000 or more, in which case no results are generated and this error appears:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.
all_bin_results.asp, line 8
Line 8 of the code:
strInputList = Trim(Request("strInputList"))
Does anyone know what's causing this error?
Thanks in advance - Matt