Re: *** HELP *** Problems Accessing Simple VB.NET Access Database

ASP.Net runs under a user account so you can grant it rights as you can with
anny user

as an alternative you can use impersonation

see this for details :
http://support.microsoft.com/kb/317012/

you can grant Write permissions for the ASPNET account. You can grant Write
permissions for an individual file or for directory hierarchies.

Important When you grant Write permissions for an individual file or for
directory hierarchies to the ASPNET account, all ASP.NET Web applications
that are running under the ASPNET account on the server are also able to
write to this file or the directory hierarchies ( however if you created a
specific directory this should not be a problem )






"samadams_2006@xxxxxxxx" wrote:

Right, I'm using Visual Studio 2003. Ok, I'll put the database in
"C"\Databases" which is out side INETPUB. How do I "grant the rights
on this directory for the Asp.net worker processes" ?

Thanks.


Michel Posseth [MCP] wrote:
This is an easy one :-)


Rights ,,, in the 2005 version you can create a special data subdirectory ,
however in previous versions i would recomend to create a subdirectory
outside the inetpub and grant the rights on this directory for the Asp.net
worker processes


regards

Michel Posseth [MCP]



<samadams_2006@xxxxxxxx> schreef in bericht
news:1154212738.853858.100840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I'm having a problem in accessing a Microsoft Access Database in a
VB.NET Web Application. It's so straight forward, I thought I'd walk
you through all the details here:

1) I have a .NET Web Application called "Lesson18b" under
"C:\Inetpub\wwwroot\Lesson18b".

2) I have one Web Form on this Lesson called "Form18b.aspx"

3) In this same Folder under Inetpub I have the Microsoft NorthWinds
Access Database called "FPNWIND.MDB"

4) I add an OleDBConnection called OleDBConnection1 to Form18b.aspx.
I set the "New Connection" Properties to: Provider is "Microsoft
Jet 4.0 OLE DB Provider". Database Name is "FPNWIND.MDB". User
name is "Admin". Blank Password is checked. I test the connection
and it states that the "Test Connection Succeeded". I choose not
to include a password in the connection string.

5) I then add an OleDBCommand called OleDBCommand1 to Form18b.aspx. I
set the connection to OleDBConnection1. For the command text I select
the "..." and when asked, I add table "Customers". I move
"All Columns" to the grid below, producing the SQL "SELECT
Customers.* FROM Customers". When I right click the bottom
grid and choose "Run", it fills the grid with data. So far, so
good.

6) To Form18.aspx I add a text field called "txtResults" and a
command button called "Button1".

7) Double-clicking on "Button1", I add the following lines of
code:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim dr As OleDb.OleDbDataReader
OleDbConnection1.Open()
dr = OleDbCommand1.ExecuteReader
While dr.Read
txtResults.Text = dr.GetValue(0)
End While
End Sub

8) When I build, then run the application, and click on "Button1",
I get the following error:

We can't find http://localhost/Lesson18b/Form18b.aspx
Error - Internal server error

9) If I debug the application, it bombs on the following line in
Button1:

OleDbConnection1.Open()

I'm trying to get the data to display on txtResults. This code works
fine in a regular VB App...but for some reason it will not work on this
Web VB App.

Does anyone have any ideas on why this is happening?



.