Solutions to several problems encountered by ASP

I,

Microsoft ole db provider for ODBC drivers error '000000 ′
System Environment:
Operating System: Windows Server 2003 Enterprise
Web server: IIS6
Disk format: NTFS
Database: Access
Error message: Microsoft ole db provider for ODBC drivers error '000000' [Microsoft] [ODBC Microsoft Access driver] an updatable query is required. Or Microsoft ole db provider for ODBC drivers error '000000' [Microsoft] [ODBC Microsoft Access driver] cannot be updated. The database or object is read-only.
 
Solution: Open the properties and Security tab of the corresponding database (*. mdb) file, add or modify the "Internet Guest Account (IUSR_machinename)" permission, and allow "write ".

 

 

2. Enable IE to display useful information for programmers

IE-> Internet properties-> advanced-> display friendly HTTP Error messages (remove this check box)

 

3. Add multiple websites to IIS

Right-click "new"-> "..." (several steps are the same as normal)-> use different ports

Note: if these ports have been blocked by the server firewall, you need to open them.

How to open a port: Control Panel> Windows Firewall> exceptions> Add a port

 

4. For the Asp.net program, select the Asp.net version.

Method: website Properties> Asp.net tab> Asp.net version

 

5. Add default content documents

Method: Choose website Properties> document tab> Add (for example, index. asp is not found by default, You need to manually add it .)

 

VI,

In the current ewebeditor, the upload restrictions are modified in the settings. The system will also prompt "select a valid File". In Windows 2003, the default size of files uploaded by IIS is limited to kb. Therefore, the IIS configuration is modified to solve the problem.

The modification method is as follows:

I. Solve the default file size uploaded in Windows 2003:

1. Modify "allow direct configuration database editing" to check the status;

2. When the IIS adminservice service is disabled in the service, the system will prompt that the World Wide Web Hing service and http ssl services will also be stopped. (Remember: you need to manually start these two services after the change !)

3. Find metabase. xml under Windows/system32/inesrv/and edit aspmaxrequestentityallowed to the desired value. The default value is 204800, that is, 200 K is changed to the value you need.

4. You need to use the IISADMIN service and restart it.

Note:

Notepad.exealso requires you to use the notebook to modify it. You do not need to use the wordpad.exe tablet to modify it. Otherwise, an error will occur. The IIS service cannot be started!

Ii. Solve the download size limit for Windows2003

To download attachments that exceed 4 MB in IIS 6.0, follow these steps:

1. Disable the IIS adminservice service in the service.

2. Find the metabase. xml file under Windows/system32/inesrv.

3. Open it in plain text mode and find aspbufferinglimit to change it to the desired value (20 m or 20480000 ).

4. Save the disk and restart the IIS adminservice.

 

 

VII,

Server. mappath () Error 'asp 0175: 66661'

The path character is not allowed.

/Admin/Conn. asp, row 38

The character '...' is not allowed in the path parameter of mappath '..'.

This is caused by the absence of "enable parent path.

Operation Procedure: Choose IIS6 manager, right-click the website, choose Properties> Home directory> Configuration> option, and click Enable parent path.