Hey ya'll!

I have a problem with my IIS 6.0.

1. I cannot use Access db because IIS don't want to write anything into them... I can take out info from the db, but not put in any new info. When i try to add info to a access db i get the following message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/skit/fred/forum/inc_func_common.asp, line 595

I have tried everything :(


2. CDONTS doesn't work... I have enabled SMTP service and all the other stuff one have to enable to get that working... but it just don't wanna :(



There is nothing wrong with the script coding cause these scripts used to work when i had them at win2k adv srv. and winXPpro

Hope anyone can help me.
Cheers,
Lucas

1. Well, what have you done so far? If I notice anything you may have missed, I will let you know.

2. CDONTS has been phased out by Microsoft and is not installed on Windows Server 2003. Use CDOSYS instead. Click the link below. That should help out a great deal.

http://support.microsoft.com/default.aspx?scid=kb;en-us;810702

1) Yes it does. I've used IIS 6 with Access. Check the folder permissions and make sure the server has write access

Hey again... thanks for the help with no# 2 shane :)

In order to try to enable the write to databases i have done following:

1. I have allowed almost everything in IIS Manager -> WebService Extensions. WebDav, Server Side, Internet Data Connector, and Active Server Pages.

2. In default website -> WebDirectory i've Read, Write, Index. And i've also enabled Scripts and Executables.

That's about all i've done...

Oh, i checked if everything is write in ODBC, just in case...

BTW... if anyone wants, i've made a CDOSYS mailing script :)

Have you setup Folder Permissions in inetmgr too? Just alloowing WebDev, SSI etc isn't enough.

Yes i have...

2. In default website -> WebDirectory i've Read, Write, Index. And i've also enabled Scripts and Executables.

I have the same folder settings for the whole server... Til i get to the bottom of this problem...

The version of windows i have installed is win 2003 standard... Do you know if the settings in win 2003 web are better configured?

Thanks for helping :)

No, I'm afraid not.

I used Windows 2003 Standard too, but I was able to add records to a access database. This is very odd.

Only thing I can think of is, have set permissions in Windows Explorer (i.e. Right Click Start > Explore > Go to C:\Inetpub\wwwroot\sitename and set permissions for the directory that holds the database?)

Whenever I have had this error, it's always been due to incorrect folder permissions.

Heeey!!!

Thanks man... i think you solved it....

rightclick -> properties -> security
users (styggis/users)
And i set full control and now it works...

Damn... didn't even think of that... thanks alot man :)
I would kiss you, but im not gay :) You ever need anything, just tell me :)