469,954 Members | 1,791 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,954 developers. It's quick & easy.

Createing new ASP.Net application using VB and VS2005

When creating website applications within Visual Studio 2005, I use the File
System method because it meets the needs of our environment. In choosing the
location of the directory where the files will reside, I can choose a share
on a network file server or a local directory on my workstation. I use the
network file server share because there are others who need access to the
files as well, plus the files also get backed up.

The problem I have is when I go to access the “Security” page on the Web
Site Administration Tool (WAT), I get the following error message:

An error occurred during the execution of the SQL file 'InstallCommon.sql'.
The SQL error number is 5110 and the SqlException message is: The file
"R:\HELLOWORLD\HELLOWORLDAPP\APP_DATA\ASPNETDB_TMP .MDF" is on a network path
that is not supported for database files.

If I use the File System method and choose a local directory, I don’t get
the error message. But, the files need to reside on the network share so
working locally is not really an option.

My questions are many. Is there a permissions issue that I’m missing(I’ve
tried many)? If I stay with the network file share will all web.config
changes need to be done manually? If I configure the web.config manually,
will I miss something by not having the ASPNETDB.MDF file in the App_Data
folder? Do I need the ASPNETDB.MDF file in the App_Data folder or is it just
backup? Even though I changed SQL providers from the local SQL Express to
the stand alone SQL 2000 server, I was not able to see any of the
configuration data in the SQL 2000 server tables so I suspect that the
ASPNETDB.MDF file has some value. Is there any kind of work around that I
can configure? The SQL data source has been configured using both the local
SQL Express as well as an install of SQL 2000 on a stand alone server.

Thanks in advance for your help.

--
Scott
Feb 19 '06 #1
1 2744
ScottB wrote:
When creating website applications within Visual Studio 2005, I use
There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person here who
can answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.aspnet.
the File System method because it meets the needs of our environment.
In choosing the location of the directory where the files will
reside, I can choose a share on a network file server or a local
directory on my workstation. I use the network file server share
because there are others who need access to the files as well, plus
the files also get backed up.

The problem I have is when I go to access the "Security" page on the
Web Site Administration Tool (WAT), I get the following error message:

An error occurred during the execution of the SQL file
'InstallCommon.sql'. The SQL error number is 5110 and the
SqlException message is: The file
"R:\HELLOWORLD\HELLOWORLDAPP\APP_DATA\ASPNETDB_TMP .MDF" is on a
network path that is not supported for database files.


I think you need to use the UNC path rather than the mapped drive.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Feb 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by David Thielen | last post: by
3 posts views Thread by jeffrey.bigham | last post: by
1 post views Thread by brettmetcalfe | last post: by
4 posts views Thread by Lonifasiko | last post: by
19 posts views Thread by nyhetsgrupper | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.