Hosting Classic ASP on Server 2008 R2

by Joe Payne 3. Februarie 2015 15:31

Ran into a problem today trying to light up a Classic ASP site that was a copy of an existing site on the same server.   However HTTP 500 errors were all we could get.   Once we enabled debug logging in ASP, we saw that there was a problem with the ADODB connection being able to open the MSAccess database within the site folders.

 

Gotta remember to enable 32-bit apps in the application pool advanced settings.

 

Note: Microsoft Access databases have been popular for many years with developers who use Active Server Pages (ASP) for small-scale applications, but Microsoft Access databases are not designed for scalability, therefore Access databases should only be used where performance is not a factor, and it is best not to host large-scale data-driven applications with Microsoft Access databases.

In IIS 7.0, IIS 7.5, and above, several security changes were made that may affect how classic ASP applications will function. For example, if you were to copy a classic ASP application that uses an Access database that is within the Web site's content area to a server that uses IIS 7.0 or above, you may receive the following error message:

Microsoft JET Database Engine error '80004005'
Unspecified error.
/example.asp, line 100

This is a generic error triggered by the Access driver that may occur for a variety of reasons, but incorrect permissions is a common cause. More specifically, the ability to work with Microsoft Access databases is implemented through the Microsoft JET Database Engine, which creates various temporary and lock files when it connects to an Access database. The following sections will discuss some of the reasons why this may occur and how to resolve those situations.

Working with 64-bit Systems

Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:

  1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. In the Connections pane, click Application Pools.
  3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
  4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
  5. Click OK to close the Advanced Settings dialog.

Tags: ,

Personal | Tech Support

Wordpress file upload size HTTP 404 error greater than 1mb IIS 7.5

by Joe Payne 3. Oktober 2013 10:52

A default install of Server 2008 with IIS 7.5 will force Request Filtering to 1000000 bytes.   That’s 1mb.

So a non asp.net website (i.e. PHP only) will always be limited to 1mb upload size.

This assumes you’ve already updated your PHP.ini with the appropriate size limits as widely documented on the internet.

To fix this, click on your website in IIS Manager.  In the IIS section of the website, double-click Request Filtering.

Now, on the right side click Edit Feature Settings.   There you will find the default limit of 1mb (in bytes), change it to something larger.   Restart the site.

Tags: , , , ,

Month List