SQL Update query fails

[balu chettri]

confused: When I install my web site on D: drive, sql update query through ADO connection in ASP fails with error message "Query not updatable" or "Database is readonly", although I open it in write mode. There is no such problem and it works well when web site is installed on C: drive. My D: drive is NTFS formatted while C: drive is FAT. Please help me!: Balu Chettri

[JUNEYT]

I think it has nothing to do with drivers but permissions for the specific directory. Therefore, whereever you placed the databsse, give (RW)permissions both to directory and the database. I think that will solve the problem. :wtf: