SQL and ASP

[MC]

I'm trying to use ASP pages generated in Frontpage to update an SQL server
database. I can view information from the database but cannot update, I
just get a message saying an error has occured. I am not too worried about
security, I'd be happy with one login that has the rights to do anything in
the database, create, delete, etc So 2 questions:-

What's the easiest way of making a user account that has access to all db's
Where are the error logs for the ASP page attempting to update the DB
stored?


Thanks in advance!

[Ray at]

Re: SQL and ASP

Please do not post to so many groups! And please do not post over and over
and over again!

microsoft.publi c.inetserver.as p.db ONLY WOULD BE FINE.

Ray at work

"MC" <maxcoppin@-don't-send-me-any-spam-btinternet.com> wrote in message
news:Ua8oc.82$s D1.12@newsfe6-win...[color=blue]
> I'm trying to use ASP pages generated in Frontpage to update an SQL server
> database. I can view information from the database but cannot update, I
> just get a message saying an error has occured. I am not too worried[/color]
about[color=blue]
> security, I'd be happy with one login that has the rights to do anything[/color]
in[color=blue]
> the database, create, delete, etc So 2 questions:-
>
> What's the easiest way of making a user account that has access to all[/color]
db's[color=blue]
> Where are the error logs for the ASP page attempting to update the DB
> stored?
>
>
> Thanks in advance!
>
>
>[/color]