Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Web App and Insert Record

Author  Topic 

Livvy
Starting Member

3 Posts

Posted - 2002-11-20 : 14:21:23
I use UltraDev 4.0 and ASP to access my SQL database. In my web app I have no problems editing or deleting records, but I cannot insert a record.

Is there is a special permission on SQL that needs to be set in order for users to add a new record to the database? I do have my database set up to increase 10% when it's necessary. When I submit new data, I receive the generic 404 page cannot be found error.

Any ideas on what might cause this? I've never had this problem with Access and ASP.

Thank you in advance!

Andrea

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-11-20 : 14:41:34
404 is an http error and has nothing to do with sql server.

"Is there is a special permission on SQL" ... yes. Read the chapter on Managing Security in SQL Server Books Online.

Jay White
{0}
Go to Top of Page

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-11-20 : 16:54:27
Take a look at where the form is being submitted and see if that asp page exists.

Go to Top of Page
   

- Advertisement -