Macromedia dreamweaver 8-using dreamweaver User Manual
643
29
CHAPTER 29
Troubleshooting Database
Connections
Connections
This chapter describes some common problems you might encounter after creating a database
connection, and describes ways to fix them.
connection, and describes ways to fix them.
Troubleshooting permissions problems
One of the most common problems is insufficient folder or file permissions. If your database
is located on a Windows 2000 or Windows XP computer and you receive an error message
when you try to view a dynamic page in a web browser or in Live Data mode, the error may
be due to a permissions problem.
is located on a Windows 2000 or Windows XP computer and you receive an error message
when you try to view a dynamic page in a web browser or in Live Data mode, the error may
be due to a permissions problem.
The Windows account attempting to access the database doesn’t have sufficient permissions.
The account might be either the anonymous Windows account (by default,
IUSR_computername) or a specific user account, if the page has been secured for
authenticated access.
The account might be either the anonymous Windows account (by default,
IUSR_computername) or a specific user account, if the page has been secured for
authenticated access.
You must change the permissions to give the IUSR_computername account the correct
permissions so the web server can access the database file. In addition, the folder containing
the database file must also have certain permissions set to write to that database.
permissions so the web server can access the database file. In addition, the folder containing
the database file must also have certain permissions set to write to that database.
If the page is meant to be accessed anonymously, give the IUSR_computername account full
control to the folder and database file, as described in the procedure below.
control to the folder and database file, as described in the procedure below.
Additionally, if the path to the database is being referenced using UNC (\\Server\Share), make
sure the Share Permissions give the IUSR_computername account full access. This step applies
even if the share is on the local web server.
sure the Share Permissions give the IUSR_computername account full access. This step applies
even if the share is on the local web server.
If you copy the database from another location, it might not automatically inherit the
permissions from its destination folder. You might have to change the permissions for the
database.
permissions from its destination folder. You might have to change the permissions for the
database.