HTTP Error 500.100-Internal Server Error-Asp error cannot be used (unknown) File

Create an ASP Dynamic Webpage using Dreamweaver today

Function to connect to the Access database to add a record set for a webpage

 

Error format:

Cannot browse ASPProgramBut you can browse the HTM static webpage.

 

The following error message is displayed:

 

 

 

HTTP 500.100-Internal Server Error-Asp Error
Internet Information Service

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft ole db provider for ODBC drivers (0x80004005)
[Microsoft] [ODBC Microsoft Access driver] cannot use '(unknown)'; the file is in use.
/Index. asp, row 5th

..............

 

I checked a lot of information on the Internet: most of them thought that the ACCESS database was not closed when I checked it in the browser.

But the problem is that I have never opened access

So this road won't work ....

 

 

 

Finally found an articleArticle, Explains the cause of the internal error http500 ---- computer account password error, and gives a detailed solution, but it is too complicated (http://hi.baidu.com/pubby/blog/item/e75db0314c593fa95edf0ed6.html)

 

However, I finally found another article on the Internet. I used the method to solve this problem, and the method was relatively simple. There are three steps in total, which can be considered as two steps:

 

1 run: regsvr32 % WINDIR %/system32/VBScript. dll (in fact, this step can also be saved, make sure to execute it in case)

 

2 run: MSDTC-resetlog

 

3. Check whether "IIS Out-of-process pooled Applications" is available"

View method: (1) control panel> Management Tools> component services

(2) choose "component service"> "computer"> "my computer"> "COM + application"> "IIS Out-of-process pooled Applications"

(3) If "IIS Out-of-process pooled Applications" is not found, or you cannot open "COM + application" after clicking "MSDTC-resetlog, reinstall IIS.

 

 

 

I personally think that steps 1 and 2 are the most important, and step 2 is mainly to see if there is any such item.

Note: 1 Microsoft only provides a management script adsutil. vbs with iis5. this script is located in the C:/inetpub/adminscripts subdirectory. First, register VBScript. dll.

2 msdtc.exe is a distributed transmission Coordination Program of Microsoft. This process calls Microsoft Personal Web server and Microsoft SQL Server. This service is used to manage multiple servers and must be enabled properly.

 

 

References:

Http://yangbin210.javaeye.com/blog/421670

 

Http://hi.baidu.com/pubby/blog/item/e75db0314c593fa95edf0ed6.html

 

Http://hi.baidu.com/jimmy_lee/blog/item/de5f8a8f12c04bf2513d92f5.html

 

Http://blog.sina.com.cn/s/blog_61bc863f0100gb9c.html