Got error 800a0cb3 from the Web log file at Windows Server 2008. It is IIS7. The Web application is made by ASP. Actually classic ASP, not ASP.Net.
And also with Access database. The page is try to add new record into the Access database file. But the browser return 500 internal error. The detail error code in log file is 800a0cb3 with the description: Recordset does not support updating. This may be a limitation of the provider or of the selected locktype.
I did a lot of research and found it is a right issue.
Continue reading “Classic ASP program with Access database on Windows server 2008”
When I start to use Windows 2008 with IIS 7, I can not find the place to change time of script.
I have a ASP page which will go through whole database about 20MB, and retrieve the result and put into another database. Sometimes it takes about 3 minutes to finish.
I know how to change the IIS settings in IIS 5 and IIS 6. Now it is 7, I am lost.
Later I found the help page from Microsoft IIS site.
It describe the all limits settings of IIS 7.
The bufferingLimit attribute sets the maximum size of the ASP buffer. If response buffering is turned on, this attribute controls the maximum number of bytes that an ASP page can write to the response buffer before a flush occurs.
The maxRequestEntityAllowed attribute specifies the maximum number of bytes allowed in the entity body of an ASP request. If a Content-Length header is present and specifies an amount of data greater than the value of maxRequestEntityAllowed, IIS returns an HTTP 403 error response.
The processorThreadMax attribute specifies the maximum number of worker threads per processor that IIS may create.
Note: This setting can dramatically influence the scalability of your Web applications and the performance of your server in general. Because this attribute defines the maximum number of ASP requests that can execute simultaneously, this setting should remain at the default value unless your ASP applications are making extended calls to external components.
The queueConnectionTestTime attribute specifies the number of seconds that a request can be queued before ASP determines whether the client is still connected. If the request is queued longer than the number of seconds specified by the queueConnectionTestTime attribute, ASP checks to determine whether the client is still connected before executing the request. If the client is no longer connected, the request is not processed and is deleted from the queue.
Continue reading “ASP Limits “
I have a dream, mentioned in my Chinese Blog. I want to replce the current Windows 2003 server by a Linux server.
There are something to do before I move to Linux.
I am familiar with the Windows just like lots of other people who runs a Windows desktop.
Now for Server side, Linux, Bind, Apache, MySQL, postfix, and many server software are all running well.
The problem is I have to redesign my sites to PHP, MySQL. It is a big job.
It took me about 8 hours to convert G2Soft, main site of my Pentacle In-Out Board.
There are still some other sites I runing on this Windows server. I have to convert them one by one to a new site.