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!
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!