Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 1st, 2009, 06:28 PM
Authorized User
Join Date: Oct 2006
Posts: 42
Thanks: 3
Thanked 0 Times in 0 Posts
Default Question about Config file/database schemas


This question straddles the Oracle and ASP.NET worlds -- I hope this is the right place for it:

I'm working on a legacy ASP.NET 2.0 website that uses an old Oracle database on the backend. There is also an admin console wepapp which services the main website, but is a seperate application, not an Admin subfolder.

The Oracle database has two "schemas", named WEBSITEADMIN and WEBSITEUSER, which have identical tables and stored procedures. Oracle seems to use the word "schema" to refer to groups of tables within a database - i.e. the two schemas seem to actually be distinct and seperate, as when I add columns to a table in the WEBSITEADMIN schema, the additions do not appear in the same table under the WEBSITEUSER schema.

The main webapp has an <appSettings> key pointing only towards the WEBSITEADMIN schema in the Oracle database, and indeed it appear to read and write only to that schema.

The admin console website, however, has the following in its web.config folder:

     <add key="connectionString" value="user id=websiteadmin;data source=DATABASE;password=xxxxxx"/>
     <add key="DataConnection" value="user id=websiteadmin;data source=DATABASE;password=xxxxxx"/>
     <add key="domainName" value="adminsite.company.com"/>
     <add key="MachineName" value="mbd01235pd"/>
     <add key="Administrator" value="COMPANY\myemail"/>
     <add key="AdminAddress" value="myemail@company.com"/>
     <add key="ServerSideViewState" value="true"/> 
         connectionString="Data Source=DATABASE;User ID=WEBSITEUSER;Password=xxxxxxx;Unicode=True" 
...so, the admin console webapp has an "appsettings" key referring to the WEBSITEADMIN schema, but the <connectionstrings> tag refers to the WEBSITEUSER scheme... erm.. what the heck?

Any idea why this app would have connections to both schemas if the main website appears to be only displaying data from one of those schemas?

Thanks for any advice.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Yet another question about PHP and Win XP config Humberg Beginning PHP 1 August 5th, 2007 10:07 PM
Single server installation - RAID config question? alexl BOOK: Professional Team Foundation Server ISBN: 0-471-91930-6 0 April 25th, 2007 11:03 PM
New Config 2005 Reading Question Neilgott Visual Basic 2005 Basics 0 May 1st, 2006 09:30 AM
Web.Config Question RPG SEARCH ASP.NET 1.0 and 1.1 Basics 4 February 3rd, 2005 09:31 AM
IIS config question? developerz BOOK: ASP.NET Website Programming Problem-Design-Solution 0 November 15th, 2003 05:59 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.