Runs fine on local web server, but not on development web server

Posted on 2004-11-16
Last Modified: 2008-01-09
Tonight I was taking my website down inorder to migrate some database changes.  But when I went to put the website backup, I have found empty datagrids and other problems within the site.  I thought that something must have changed in the code, but when I run it from my local server, everything runs fine.  The data is pulled from the database fine, which populates the datagrids.  There appears to be no problems.  But when I move the files to development....all of a sudden there are problems.  I even tried to move other backups to the development server, and still I get problems.
Please help.
Question by:shorriga
    LVL 3

    Expert Comment

    Check your Database connection string. This is sometimes stored in the root web.config file.  Your local database connection string will usually vary from your live database string.

    Author Comment

    I don't think this is the problem as the website is still partially functioning in development.  For example, searches against the database run fine.  But then when I click on the links it brings back I get this error:

    OracleParameter object is already contained in a collection

    Again, everything works when I am running it from my local server, but not on the development despite pointing at the same data.  The only code change a made between the two migrations was uncommenting a response.redirect command that points them to a "Site Down" warning page and then commenting this line out when I was finished with the database changes.

    I just checked to see if everything works on the website in production by getting around the warning page, and it does.  Is there anyway this could be a server problem?
    LVL 3

    Accepted Solution

    yes it could, hard to diagnose with limited information / access..

    try rebooting the development server .

    does anyone else use/access the development server? someone else may have changed something..

    did you correctly move all the code to the development server? If you just put the bin file and not didnt put any modified aspx pages that could cause problems.

    based on what you are saying, the database server is fine and your code is fine. so it does look like a web server issue.. reboot.. to get rid of cache etc..

    LVL 5

    Expert Comment

    Dear shorriga,

    The best way to figure the problem out is to use remote debugging/ trace switches.


    Author Comment

    There was an upgrade made to the development server, which disallowed global declarations of OracleParameters for use in multiple stored procedures.  Now I have to specifically, declare the parameters each time I run a stored procedure.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    This video teaches users how to migrate an existing Wordpress website to a new domain.

    729 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

    23 Experts available now in Live!

    Get 1:1 Help Now