.NET Framework - Problem with Database Access and ASPX pages

Asked By RDK

22-Jan-10 06:05 AM

I just installed the initial version of Expression Web (12.0.6211.1000) SP1
MSO (12.0.6425.1000) on my XP Pro SP3.

I have been using FrontPage for years.  On this PC I have IIS running with FP
2002 extensions installed.  I also have a Window 2000 Server also running FP
2002 extensions.  My current development environment on my XP Pro machine
and also via the Server are both running fine for normal HTM and ASP pages,
including access to various SQL and Access databases.

I purchased Expression Web as the FrontPage replacement but never got around
to installing it until now.

Yesterday I tried to use Expression Web to create a simple database
connection page to just display items in an Access table. Code shown below:
=========================================
DataFile="Databases/PatsDB.mdb" SelectCommand="SELECT [Author],
[Title/subject] AS column1 FROM [BookReviews]">
===========================================

Normal HTM pages run fine but when I try to run this ASPX page on either my
local IIS site or from my Windows 2000 Server IIS site I get this error
message:
===========================================

Server Error in '/Pat' Application.
--------------------------------------------------------------------------------

Server cannot access application directory 'D:\Webs\wwwroot\Pat\'. The
directory does not exist or is not accessible because of security settings.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Server cannot access
application directory 'D:\Webs\wwwroot\Pat\'. The directory does not exist
or is not accessible because of security settings.

Source Error:


An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.


Stack Trace:


[HttpException (0x80004005): Server cannot access application directory
'D:\Webs\wwwroot\Pat\'. The directory does not exist or is not accessible
because of security settings.]
System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263

[HttpException (0x80004005): ASP.NET Initialization Error]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +983
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128


===============================================

What is going on and how do I correct it so I can continue looking at
Expression Web?....RDK

22-Jan-10 09:07 PM

The errors you are getting seem to suggest the folder "Pat" does not exist but
I would say it is a mis-configuration on the server. Have you installed,
configured  ASP .Net for your server(s)?

Can you try previewing the page in a browser (using the in-built development
server in EW) and make sure you have the settings for previewing ASPX pages
to on (under options > application settings or similar)?  If the page loads
and functions correctly, you know it is a problem with your IIS
configuration.

I tried a Google search (search term: "Exception Details:
System.Web.HttpException: Server cannot access > application directory.")
and came across this: http://support.microsoft.com/kb/825789

Try the solution suggested and see if you continue to experience the errors
you have outlined.

I would also ensure you have the latest ASP .Net version (3.5)

Other members may have some ideas as they may be more expert in .Net and IIS
than myself.

23-Jan-10 04:53 AM

Which version of .NET is the website set up to use?  The default is .NET
1.4, but Expression Web uses v 2.xxxxx
The stack trace indicates .NET is not correctly set up on the web server(s).

Apart from the set up problems, the page will not display anything - a
datasource points to the data, but you need something to display the data
in - a gridview, datalist, repeater etc.
So the page should be similar to: (I used a gridview in this example).  Also
notice the language declaration, which EW will insert automatically if you
use  new page and choose .aspx.





DataSourceID="AccessDataSource1">
SortExpression="AuthorID">
SortExpression="PageID">
DataFile="fpdb/rxs_data.mdb" SelectCommand="SELECT [AuthorID], [PageID] FROM
[Authorised_pages]">




--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.

23-Jan-10 07:57 AM

Andrew and Ron....Thank you for your comments.  As I am 100% new to
Expressions Web and .NET, I probably have not configured everything
correctly on my XP Pro development PC and on my Windows 2000 server, so any
hints would be very much appreciated.

For now I have only installed the original version of Expression Web (as
Indicated in my original post).  I just now checked IIS on this XP Pro
machine and it had ASP.NET version 1.1.4322 in the dialog.  I clicked on the
pulldown and selected 2.0.50727. I reconstructed my test page with a
datagrid as suggested and re-ran it.  I got a similar error pointing to the
web.config file access problems.
==========================
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed
to start monitoring changes to 'D:\Webs\wwwroot' because access is denied.

Source Error:

[No relevant source lines]

Source File: D:\Webs\wwwroot\web.config    Line: 0


==========================

I had read that MS Support link page before and could not find a VSWebCache
folder on my XP Pro PC.  I did not check on Windows 2000 server as I want to
experiment with my XP Pro PC first.

Regarding ASP.Net installation, I have never done anything special with
ASP.Net.  I have several updates which show up on my MS Updates list which
were installed automatically.  Should I install/configure something else?

Also, I do not find any references to a way to preview my page in Expression
Web.  From the File menu I can select Preview, but that just opens up a
browser and points to the server.  What am I missing?

Thanks again for your help and patience.....RDK