64-bit Win7 of IIS7 ASP and Access connection problems _ Application Tips

Recently upgraded the computer host, Taobao bought, the seller put me a 64-bit Win7 and some basic procedures.

I have a small program is ASP, to let it run, so install IIS (before adding a removal program, now called to turn on or off Windows features, look for a good while), put the web, found has been running, a page blank.
I haven't touched the ASP program for a long time, but I still have a little impression. So open the program, find the connection to the database after the paragraph, add a sentence: Response.Write Err.Description, prompted not to record down, probably did not find the right application.
Look at the next machine, there are word,excel and so on, no access. Re-installed the next office2003, with access.

Web run, Hint: Provider not found. The program may not be installed correctly.

Original program

conn.connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Server.MapPath (AccessPath& "/" &accessfile)
Conn.Open

I changed it to:

Conn.Open "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= "& Server.MapPath (accesspath&"/"&accessfile") & ";"

Tip: [MICROSOFT][ODBC driver Manager] did not find the data source name and did not specify a default driver

Previous experience, may not open the parent path, in IIS found under the enabled, or the same.

Search the next, found the problem in IIS7 body.

The general-> enabled 32-bit application in the application pool default is False to True by default.

This prompt:

Former: Error database connection error not specified, check the connection string

The latter: [microsoft][odbc Microsoft Access Driver] Microsoft Jet Database engine cannot open file ' (unknown) '. It has been opened exclusively by another user or does not have permission to view the data.

Continue to find ways:
The Windows/temp folder is missing a user group right and the missing user group is authenticated users.

Then add the Authenticated Users group to this folder for read and write permissions.

The problem is solved!

' Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft] [ODBC Microsoft Access Driver] Cannot find the file ' (unknown) '.
/conn/conn1.asp, line 3rd '
The IIS7.0 configuration is set correctly in Windows7, and the ASP is set correctly
Permission issue, but it will pop up as error at run time!
My database Connection code is:

Copy Code code as follows:

<%
Set conn = Server.CreateObject ("ADODB. Connection ")
Conn.Open "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= "& DefaultDir &server.mappath (" Worker.mdb ") &"; "
Set rs = Server.CreateObject ("ADODB.") Recordset ")
Set rs1 = Server.CreateObject ("ADODB. Recordset ")
Set rs2 = Server.CreateObject ("ADODB. Recordset ")
Set RS3 = Server.CreateObject ("ADODB. Recordset ")
%>

The network spread many versions of the explanation, after I try to solve the method:
Windows/temp folder is missing a user group permission
Typically, the missing user group is authenticated users in the Windows7 default installation of IIS
Add to
Authenticated Users

The default permissions are read, write. OK, the system is running normally

Win7 or Windows 2008 64-bit systems, asp+access database Connectivity Error Resolution

Win7 or Windows Server 2008 IIS7 is not installed by default, so if you need to install IIS7 after installing Win7 or Windows Server 2008, you'll have to do it yourself. The steps to install are: Start Control Panel program turn on or off Windows features Internet Information Services. IIS7 installation needs to be aware of, if you need ASP, ASP. NET, and so on, is required to install the function module, the default is not installed.

Win7 or Windows 2008 64-bit Systems resolve Access database problems in IIS7.

If you use a 64-bit system, it may not work as well because the 64-bit system does not provide a 64-bit access connection driver, and the "Enable 32-bit application" for projects in the corresponding application pool of the Web site is "ture". That's it.

Other tips in IIS7:

A. Enable the parent path.
Commonly used in ... /parent path used in IIS7 is not supported by default.
On the home page of IIS-->asp-> double hit Open-> enable parent path: True

B. Return an error message to the browser.
Default page code error browser will appear "An error occurred on the" processing the URL. Please contact the system administrator.
On the homepage of IIS-->asp-> double hit open-> debug error-> send error to browser: True