80004005—Couldn’t use ‘(unknown)’;
file already in use
This error occurs when you use a Microsoft Access database and attempt to
view a dynamic page in a web browser or in Live Data mode. Another variation
of this error message is “80004005—Microsoft Jet database engine
cannot open the file (unknown).”
Cause and Solution:
• The account being used by Internet Information Server (usually IUSR)
might not have the correct Windows NT permissions for a file-based database
or for the folder containing the file. Check the permissions on the IIS account
(IUSR) in the NT user manager.
• You might not have permission to create or destroy temporary files.
Check the permissions on the file and the folder. Make sure you have permission
to create or destroy any temporary files. Temporary files are usually created
in the same folder as the database, but the file may also be created in other
folders such as /Winnt.
• In Windows 2000, the time-out value may need to be changed for the
Access database DSN. To change the time-out value, choose Start > Settings
> Control Panel > Administrative Tools > Data Sources (ODBC). Click
on the System tab, highlight the correct DSN, and click on the Configure button.
Click the Options button and change the Page Timeout value to 5000.
ColdFusion—Access Denied
This error occurs with ColdFusion 4 or 5 when writing to a file-based database
(such as Microsoft Access or Foxpro) that ColdFusion is accessing through
a data source. The error usually occurs when you try to overwrite the file
through FTP or by copying over it.
The workaround is to recycle the ColdFusion services or disable “Maintain
Database Connection” from the Data Source section in ColdFusion Administrator.
ColdFusion—Operation must use an updateable
query error
This error occurs with ColdFusion 4 or 5 when attempting to run a ColdFusion
page that updates or deletes from a Microsoft Access (or other file-based)
database.
This error usually occurs because ColdFusion does not having appropriate permissions
at the network operating system level to write to the database.
To solve this issue in Windows NT, click Start > Settings > Control
Panel > Services. Double-click the ColdFusion Application Server service
and note the start-up account. It should be the System account by default.
Next, go to the folder containing the database file and explicitly give the
noted account full permissions to that folder. Even if the folder says “Everyone”
has full permissions, add the ColdFusion startup account.
80004005—Data source name not found and no default driver specified
This error occurs when you attempt to view a dynamic page in a web browser
or in Live Data mode. The error message may vary depending on your database
and web server. Other variations of the error message include:
• 80004005—Driver's SQLSetConnectAttr failed
• 80004005—General error Unable to open registry key 'DriverId'
Cause and Solution:
• The page can’t find the DSN. Make sure a DSN has been created
on both the web server and on the local machine.
• The DSN might have been set up as a user DSN, not as a system DSN.
Delete the user DSN and create a system DSN to replace it.
Note: If you don’t delete the user DSN, the duplicate DSN names produce
a new ODBC error.
• If you use Microsoft Access, the database file (.mdb) might be locked.
The lock might be due to a DSN with a different name accessing the database.
In Windows Explorer, search for the lock file (.ldb) in the folder containing
the database file (.mdb) and delete the .ldb file. If another DSN is pointing
to the same database file, you may want to delete the DSN to prevent the error
in the future. Be sure to reboot the computer after making these changes.
|
|
|
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|||||
|
|
|||||||
|
|
|
||||||
|
|
|||||||
|
|
|
|
|||||
|
|
|||||||
|
|
|
|
|||||
|
|
|||||||
