shorriga
asked on
Runs fine on local web server, but not on development web server
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.
Please help.
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.
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dear shorriga,
The best way to figure the problem out is to use remote debugging/ trace switches.
Regards,
me
The best way to figure the problem out is to use remote debugging/ trace switches.
Regards,
me
ASKER
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.