inability to save data
-
Hello,
I recently built a dev server -Windows2003Server box running IIS6 and SQL2000 with SP3 for a production website. I then imported the data from the production database to the dev database. I then created a SQLuser with permissions to select, update, insert, yada, yada. When I fire up the dev website and login to the admin section, I can modify or delete any of the existing data, but I cannot add any new data. The database is not full, and it is set to grow. My user account has Select, update, insert, delete and DRI on all tables. I am able through Query analyser to insert data into the tables, but not through the web gui.
A side note, the production environment is a Windows2000Server running IIS5 and SQLServer2000. So I'm not sure if my problem is OS, IIS or SQL
Any help would be appreciated.
-
Does the table that you are attempting to enter data into have a Primary|Unique key? I know Access has a similar problem and so does EM when the table doesn't have a PK..
Good Hunting!AJ Ahrens
webmaster@kritter.net -
The primary keys were not set, I made that change, but it still does not work.
-
Are you getting an error? I know you say that you are trying to add records through the web.. How? Is it via stored-procedure call?? Do you have rights to EXEC??
Good Hunting!AJ Ahrens
webmaster@kritter.net
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply