You receive a connection error message when you create a database connection or locate a database (243331)
The information in this article applies to:
- FrontPage 2000 Server Extensions from Microsoft
This article was previously published under Q243331 SYMPTOMS 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) 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. CAUSE 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. RESOLUTION 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.
Modification Type: | Major | Last Reviewed: | 8/2/2004 |
---|
Keywords: | kbASP kbDatabase kberrmsg kbprb KB243331 kbAudDeveloper |
---|
|