RE: IIS6 database link

From: Vijay R Gangolli [MSFT] (vijgang_at_online.microsoft.com)
Date: 03/14/04 

Date: Sun, 14 Mar 2004 08:56:58 GMT

Hi Martz,

To write to the database you need to ensure the following,

1. The IIS Website is a 'Application' under IIS Manager (the folder with
the global.asa file must be set to an Application)
 i.e Under IIS Manager-> Right click on Virtual Directory -> Properties ->
Directory or Home Directory Tab -> Click the "Create" button under the
Application settings. [This might be the most probable reason].
2. If you are running under IIS 6 Isolation mode [sort of IIS5], then
ensure that the account used to browse (if anonymous IUSR_..), this account
must have modify permissions on the DB.
3. If you are running under IIS 6 default mode, then ensure that the
account used by the App Pool to browse to the Page must have modify
permissions on the DB.
4. If you are not sure which account is used, just check the IIS log files
to see which account is used to access the Formpage and ensure that has
modify permissions on the DB.

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: mmartz <mmartz.132n4u@mail.forum4designers.com>
| Subject: IIS6 database link
| Date: Sat, 13 Mar 2004 12:52:04 -0600
|
We are in the process of moving our client sites from IIS4 to WS2003 and
IIS6. Several of the sites use a FrontPage form that links to an Access
database on the web server. They were created using the FP tools and
databse connection provided through the FP extensions.
|
| Since the move to IIS6.0, the forms have not been able to write to the
database. When you submit the form, you receive a confirmation page and
it appers to the user that it worked. Hower, the record is not written
to the database.
|
| This is an application that has been in place for several years. I open
the site in FP and checked the database connection in FP and everything
looks ok but obviously isn't.
|
| Could it be permissions? We have run into issues with the default
permission issues in IIS6.0.
|
| Thanks for the help. 

--
mmartz
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message57880.html
 
|
Loading