Last post Feb 19, 2010 09:08 AM by msdevm
Feb 17, 2010 10:42 AM|msdevm|LINK
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up.
Any idea what else do I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
Feb 17, 2010 11:03 AM|hans_v|LINK
I gave IIS_WPG write/modify access
Sounds like a permissions problem.
On Windows Server 2003, it is the NETWORK SERVICE account you should give permissions, if you've ASP.NET impersonation enabled, it is the IUSR_machinename :
Feb 17, 2010 07:25 PM|msdevm|LINK
Thank you for reply, I have the IUSR_machinename as well with read/write/modify permission
Any other idea.
Feb 17, 2010 07:29 PM|hans_v|LINK
it would help if you can give us the error code. Otherwise we'll have to guess...
Feb 19, 2010 09:08 AM|msdevm|LINK
Guys I appology I thought I had flagged (read/write/modify) permission on iusr_machinename and I checked again I only had (Read/Write) and no modify checked
Thank you again