WIN10 problems and solutions encountered by debugging ASP programs under IIS

Recently maintained an ASP system previously written by others, documenting the problems and solutions during the debugging process.

Environment World Wide Web Publishing Service (W3SVC) has stopped

Questions :
The World Wide Web Publishing Service (W3SVC) has stopped. The Web site cannot be started unless the World Wide Web Publishing Service (W3SVC) is running.

Workaround :

You need to start the entire application first.

IIS Services

Control Panel >> programs and features >> start or shut down Windows features >>iis service

However, this only opens the IIS service, there will be a Http500 error, cannot run the ASP program, because the IIS server by default does not help us configure the ASP or the ASP. NET environment, we need to manually configure (in the process, I started multiple computers).

Configuring an ASP Environment

The ASP configuration is as follows:

If you need ASP, you need the following configuration:

An error occurred IIS7 in the server when processing the URL is wrong

Error description :
An error occurred on the server when processing the URL. Please contact the system administrator. If You is the system administrator please click here to find out more about this error.

1. Open Control Panel → Administrative Tools →internet information Services (IIS) Manager → Double-click the ASP icon
   
2. Find your website in the left window, then expand "Debug Properties" in the right window and set "Send error to Browser" to True
   

At this point you run the ASP program will see the specific error, and then according to the error prompts to modify accordingly.

Code article adodb.connection error ' 800a0e7a '

Specific error :
ADODB. Connection error ' 800a0e7a '
The provider was not found. The program may not be installed correctly.

reason :

This problem occurs because the system is a 64-bit win10.

Workaround :
Locate the IIS application pool, set application pool default properties, general, enable 32-bit application, set to True.

height= "100%" width= "100%"

Style= "WIDTH:757PX; height:455px; "
So the problem is solved.

ADODB. Recordset error ' 800A0CC1 '

Description :
ADODB. Recordset error ' 800A0CC1 '
The item is not found in the collection that corresponds to the desired name or ordinal.

Solution :
The field is generally incorrectly written or, your database does not have this field.

IFRAME Adaptive

JS Code:

//iframe highly adaptivefunction iframeresize(Iframename){    varPtar= Document.getelementbyidx_x_x(Iframename);    if(Ptar){ //ff        if(Ptar.contentdocument && Ptar.contentdocument.Body.offsetheight){            Ptar.Height = Ptar.contentdocument.Body.offsetheight;        } //ie        Else if(Ptar.Document && Ptar.Document.Body.scrollheight){            Ptar.Height = Ptar.Document.Body.scrollheight;        }    }}//iframe Width Adaptivefunction Iframeresizewidth(Iframename){    varPtar= Document.getelementbyidx_x_x(Iframename);    if(Ptar){ //ff        if(Ptar.contentdocument && Ptar.contentdocument.Body.offsetwidth){            Ptar.width = Ptar.contentdocument.Body.offsetwidth;        } //ie        Else if(Ptar.Document && Ptar.Document.Body.ScrollWidth){            Ptar.width = Ptar.Document.Body.ScrollWidth;        }    }}

IFRAME Box configuration:

<iframe src="Main.htm" scrolling="no" frameborder="0" height="100%"id="mainFrame" width="100%" onload=‘IFrameReSize("mainFrame");IFrameReSizeWidth("mainFrame");‘></iframe>

Access Paging

select  * from  news where  nid between  (select  min  (NID) from  (select  top 4  nid from  newsdata order  by  nid desc )) and  (select  min  ( NID) from  (select  top 1  nid from  newsdata order  by  nid desc )) order  by  nid desc   

Use the top and Min functions to find the start ID and end ID of the page, and if you want to sort in ascending order, use top and Max to find the starting ID and end ID, and then select directly using the between statement. Note Three places must be sorted in the same way, and the query conditions must be consistent.

reference Documentation :

1. Simple and efficient access paging statements

WIN10 problems and solutions encountered by debugging ASP programs under IIS