problems with updating sql records from ASP formview

Hi, I am fairly new in the ASP, but have now been working and justuploaded my web to DiscountASP.NET, I have a working SQL 2005 DB, attached and the Web site running ASP 2.0, I have a problem when I am updating a record using formview in asp.

It seem I do not have a "write access" or change permissions(no change after Isubmit "update"), but I can make a new record without any problems. I can change the records from server management Studio, but not from the formview itself.

Does anyone experince problems like this.

I check the web.config, and also check the code for problems, but I have not figure out where the problem is.
Locally I do not have that problem!!!

Please help.

Thanks

4nordic...

 

Are you using the main SQL user i.e SQL2005_**** ?
Do you get any kind of error?If yes,could you provide me with the same?


Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Hi Vikram,


I actually narrow the problem down, I used the "use optimistic concurrency" in Advance SQL Generation options within configure Data Source (VWD 2005), when I used this option UPDATE detects whether the database has changed since the record was loaded into the dataset. This helps prevent concurrency conflicts. But as I have experince, this option disable me to UPDATE any records at all. so for SHORT do not use this option !


I hope this can be of any use, for other in same problem


Thanks


4Nordic