asp.net databases problem

[EdH]

I have built a very basic asp.net website to interface with a database
following the instructions in the following MS article

http://msdn.microsoft.com/library/d...n-us/odc_fp2003_ta/html/odc_FPUsingDIWwFP.asp

While I can see all three pages (submission, results and edit) I can not add
or edit new records. I can see the contents of the dabase in the results page
and I can see the contents in the edit page but I cannot edit them. I get a
message saying that the operation failed. Same thing if I try a new entry
from the submission form.

Any ideas?
Thanks
EdH

 

[Kevin Spencer]

What database are you using? If it is Access, certain file permissions must
be set to allow the database to be updated (changed).

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[EdH]

Yes, it is Access. Where do I set the file permissions?

Thanks
EdH

 

[Kevin Spencer]

You have to determine the user account under which ASP.net is running. This
can be found in Task Manager or in your machine.config file. Then you have
to grant the necessary file permissions to that user. The file permissions
would be "change" on the folder in which the datbase resides.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[EdH]

OK thanks.

I was trying to get a way that my website members could update their
profiles in the database using DRW (as opposed to me having to write the
code). If I have to give everyone admin permissions this may not be the way
to go.

I may have to learn asp and/or asp.net coding after all!
Thanks anyway.
EdH

 

[Kevin Spencer]

Hi Ed,

No, you don't understand. Your ASP.Net app is running under ONE user
account. That's the one that needs the permissions. It is an application, a
single process. Understand?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[EdH]

OK I get it.

But I checked and I do have the right permission. I have administrator
permission to: View, add, and change all server content; manage server
settings and accounts.
That should be enough.

Anything else that could be wrong? Remember the website I made only includes
the files created in this article:

http://msdn.microsoft.com/library/d...n-us/odc_fp2003_ta/html/odc_FPUsingDIWwFP.asp

Do those files work or do I need to add anything else to them?
Thanks,
EdH

 

[Kevin Spencer]

Hi Ed,

You're getting close, but not there yet. It's not YOUR account; it's the
account under which the ASP.Net worker process is running. Every application
or process on a computer runs under a Windows user account. Which account
depends on the process, and affects the priveleges of that process. The
ASP.Net worker process is called "aspnet_wp.exe" in Windows XP, and
"w3wp.exe" under Windows Server 2003. You can use the Processes tab in Task
Manager to see what account that process is running under.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[EdH]

There is only one user and that is the administrator and that is me. I do
think that I have administrator permissions which I know is right because I
run another website in that server where I enter data into a database with no
problem.

The problem I am trying to resolve is how to update data in a database using
the DRW instead of having to program code. I don't know asp.net but I am
trying the instructions in the MS article I mentioned earlier but it doesn't
seem to work.

If you assume that the permissions are good. Are the web pages defined in
the MS article correct? Do I need to add anything to it to make it work?

Thanks again.
EdH

 

[Kevin Spencer]

Ed,

I can't help you if you don't listen. Your computer has a number of user
accounts, among which is yours. For example, there is a System account under
which most programs run. Other programs run under a variety of other
accounts. You didn't create them, any more than you created the built-in
Administrator account. Your operating system did.

Yes, you are trying to follow instructions, but you don't understand them,
and you've made a mistake somewhere. My mother once told me that people
would ask her for her recipes, and then complain that they didn't taste the
same as hers. It turns out that they didn't follow her recipe exactly.
They'd add a pinch of this here and a dash of that there. What's worse about
computers is, everything they do is math. Guess what happens when just one
number is wrong in an equation?

Now, I make a darn good living as a programmer, and I do some pretty
sophisticated stuff for a living. I am the Senior Application Developer for
my company. I am currently working on a 3D terrain modeller for small
aircraft, which runs off of a GPS, and uses USGS Digital Elevation Model
data, USGS National Land Cover data, FAA airport information data, NWS
weather data, Microsoft Managed DirectX, and Microsoft Indigo, running on
the beta version of the Microsoft .Net 2.0 platform. I'm just telling you
this to get you to trust me. I know what I'm talking about. So, when you can
snatch this pebble out of my hand, Grasshopper, you will have learned.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.

 

[EdH]

I seek to discover, Master!

Please rest assured that I certainly appreciate the help that you and others
at this forum give to us newbies! I would not attempt to tinker with your
recipes (or your Mom's) - at least until I knew what I was doing.

This is where we stand:

- the server running asp.net is at our domain hosting company
- I have contacted them and copied your comments and they will get back to
me as to what permissions the user where asp.net resides is giving to the
folder where my database resides.

I will let you know their response.

Thanks again for your help,
EdH

PS For your info: I have previously ran a website at this domain where I
entered data into a database using asp (NOT asp.net) and it worked fine.
Cheers,
EdH

 

[Kevin Spencer]

That ought to do it, Ed. Keep me apprised.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Sometimes you eat the elephant.
Sometimes the elephant eats you.