Ad Hoc Issue - Why does it work on my local development environment but not on a DiscountASP server?

Discussion in 'ASP.NET / ASP.NET Core' started by MrAirbear, Jun 7, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Background:
    ASP.NET 1.1
    SQL Server 2000

    I have an application that contains a search page. In the background of this search page is an ad hocstored proc that returns data in my development environment. In the development environment, it works perfectly - it cannot be broken. On a DiscountASP server, this page works to a point.

    Details:

    This search page contains a begin and end date dropdowns (a dropdown for month, another for day and yet another for year - nothing unique there). Following the begin and end date dropdownsthere are a five checkbox sets (five selection options) and a textbox. The combinded values of the date dropdowns (both for the begin and end dates) the comma delimated list of values from the checkboxes (if selected) and any text in the textbox provides the values for the search (text is used in a 'like' search).

    The dates work fine in the search but any selection in the checkbox lists and any text in the textbox will return nothing. Any valid selection in any of the checkbox listswill return nothing.

    The values (options) for the four of the fivecheckboxes are populated from values in the database.

    The application on the DiscountASP server does use a User Account in the database that doesn't exist in the development environment. However, in my testing I did give that user dbo access to everything in the database. The results of the search page didn't change - date selections work but nothing else.

    I downloaded and used a tool that compares the stored procedures and tables in the two databases. Both databases contain identical stored procedures and table structures.

    The db User is the only difference (that I am aware of) between the two databases/environments.

    Suggestions?
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page