Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 243331 - Last Review: August 2, 2004 - Revision: 2.0
You receive a connection error message when you create a database connection or locate a database
This article was previously published under Q243331
When you try to create a database connection in a FrontPage
Web, you may receive one of the following error messages:
Server error: Unable to retrieve the list of record sources from
a database using the connection string:
DSN=fpdb;DRIVER={Microsoft
Access Driver (*.mdb)}.
The following error message comes from the
database driver software; it may appear in a different language depending on
how the driver is configured.
-------------------------------------------------------
Source:
ADO
Number: -2146824584 (0x800a0e78)
-or-
Server error: Unable to retrieve the list
of record sources from a database using the connection string:
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/new_page_1.mdb.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
Source:
ADO
Number: -2146824584 (0x800a0e78)
If you locate an
Active Server Pages (ASP) page with a database region, you receive the
following error message in the browser:
Database Results
Error
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
This problem occurs because the Microsoft Jet Database
Engine is trying to write temporary files in your Winnt folder or
Winnt\System32 folder while the account accesses the Web. When you are
authoring the Web, the account is the logged-on user. When you are browsing the
Web, the account is the Internet Guest
(IUSR_
machinename) account.
To resolve this issue, create TEMP and TMP system
environment variables on the server. To do this, follow the steps for your
operating system.
Windows 2000
- Right-click My Computer on your desktop, and then click Properties.
- Click the Advanced tab, and then click the Environment Variables button.
- Add the TEMP variable. To do this, follow these steps:
- Under System variables, click the New button.
- In the Variable Name text box, type TEMP.
- In the Variable Value text box, type a location for your temporary folder. For example,
you can use C:\TEMP if that path exists on your
computer.
- Click OK to add the variable to your computer.
- Repeat steps a through d to add a TMP environment
variable.
- Click OK to close the Environment Variables dialog.
- Click OK to close the System Properties dialog box.
Windows NT 4.0
- Right-click My Computer on your desktop, and then click Properties.
- Click the Environment tab.
- Under System Variables, click an existing variable.
- Add the TEMP variable. to do this, follow these steps:
- Delete the value in the Variable text box, and then type TEMP.
- Delete the value in the Value text box, and then type a location for your temporary folder. For
example, you can use C:\TEMP if that path exists on your
computer.
- Click Set to add the variable to your computer.
- Repeat the steps a through c to add a TMP environment
variable.
- Click OK to close the System Properties dialog.
- Restart your computer for the changes to take
effect.
The Microsoft Jet Database Engine uses temporary files when
you work with Microsoft Access databases. The temporary folder that the
Microsoft Access database uses requires that access be granted to the Internet
Guest (IUSR_
machinename) account. If the temporary
folders are not defined in the system variables for the computer, the Microsoft
Jet Database Engine tries to create and modify temporary files in your WINNT or
WINNT\System32 folder. For security reasons, the Internet Guest probably does
not have permissions to create or modify files in those paths.
For additional information about related error
messages that you may receive when you work with the Microsoft Jet Database
Engine, click the following article numbers to view the articles in the Microsoft Knowledge Base:
251254Â
(http://kbalertz.com/Feedback.aspx?kbNumber=251254/
)
"Disk or network error" or "Unspecified error" returned when using Jet
253604Â
(http://kbalertz.com/Feedback.aspx?kbNumber=253604/
)
Microsoft Access 97 database connectivity fails in Active Server Pages
APPLIES TO
- Microsoft FrontPage 2000 Server Extensions
| kbasp kbdatabase kberrmsg kbprb KB243331 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate