Solved

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

Posted on 2007-11-28
3
208 Views
Last Modified: 2008-03-08
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



0
Comment
Question by:hennessym
  • 2
3 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 20371106
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
 
LVL 1

Author Comment

by:hennessym
ID: 20374591
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
 
LVL 1

Accepted Solution

by:
hennessym earned 0 total points
ID: 20376122
Found the solution - had to increase the AspMaxRequestEntityAllowed Metabase property.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now