Database Problem
-
My web site (ASP) fails to execute any "SQL update queries" when I install it on NTFS volume. The error message is "Operation must be an updatable query". I tried setting both Read/Write permissions on my virtual directory but there is no success. My database is not read only. There is no such problem when I install my web site on a FAT drive. Is there any security settings or User configurations that I have to set for NTFS volume? Please help me.
-
My web site (ASP) fails to execute any "SQL update queries" when I install it on NTFS volume. The error message is "Operation must be an updatable query". I tried setting both Read/Write permissions on my virtual directory but there is no success. My database is not read only. There is no such problem when I install my web site on a FAT drive. Is there any security settings or User configurations that I have to set for NTFS volume? Please help me.
Which database are you using?
-
Which database are you using?
I am using MS Access 4.0 database and ADO to connect to it but there is a problem mentioned above. B2C
-
Which database are you using?
I am using MS access 4.0 datbase and ADO to connect to it but there is a problem mentioned above. B2C
-
I am using MS Access 4.0 database and ADO to connect to it but there is a problem mentioned above. B2C
-
My web site (ASP) fails to execute any "SQL update queries" when I install it on NTFS volume. The error message is "Operation must be an updatable query". I tried setting both Read/Write permissions on my virtual directory but there is no success. My database is not read only. There is no such problem when I install my web site on a FAT drive. Is there any security settings or User configurations that I have to set for NTFS volume? Please help me.
You have to change the file permission for the file, not for the virtual directory. The write permission on the virtual directory decides what IIS allows external users to do, not what the file system allows IIS to do, so that setting should definitely not be enabled. The FAT file system doesn't support permissions at all, that's why permissions is not a problem on a FAT drive.
--- single minded; short sighted; long gone;
-
My web site (ASP) fails to execute any "SQL update queries" when I install it on NTFS volume. The error message is "Operation must be an updatable query". I tried setting both Read/Write permissions on my virtual directory but there is no success. My database is not read only. There is no such problem when I install my web site on a FAT drive. Is there any security settings or User configurations that I have to set for NTFS volume? Please help me.
http://support.microsoft.com/kb/175168[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips