Is there an upper limit to the number of items in a listbox that ASP can search for?

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



LVL 1
hennessymAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
hennessymConnect With a Mentor Author Commented:
Found the solution - had to increase the AspMaxRequestEntityAllowed Metabase property.
0
 
pssandhuCommented:
Try changing the default database for the login that you are using to connect to the server from 'master' to wahtever the database is.
0
 
hennessymAuthor Commented:
Thanks pssandhu, I tried that but am getting the same error message with the exception that the database name changed from master to ica_common (the database that contains the table).

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'ica_common'.

all_bin_results.asp, line 8

Any other ideas?
0
All Courses

From novice to tech pro — start learning today.