« Previous Next »

• 06-01-2009, 2:30 PM

  tal92 Joined on 06-01-2009, 5:45 PM Posts 2

  Problems with Access database Reply Contact Hi everybody :)  I'm using IIS 7 which ships with Windows Vista Ultimate. 've been asked to develop a website utilizing an .MDB database, based on quite basic HTML and ASP, as a part of a school project. I've been doing most of the design using IIS 6 at school, and the website runs flawlessly there (Windows XP machine). However, when I try to run it on my Vista machine (after installing and configuring IIS 7 and ASP, of course) I face a problem while connecting to the single database in the website. Initially, there was a 500 HTTP error when I attempted to submit a subscription form (utilizing that very same database), but a different login form worked just fine when I filled in present data. After looking for answers on the internet, I've disabled the 'Friendly Error Messages' feature in IE7 - however, instead of shedding some light on the problem, I now get the following message: An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error.  Problem is, I now get it while trying to login too - not only while registering. So essentially my website is rendered useless. HTML-only content works just fine, and so do regular ASP pages involving a combination of ASP & HTML - that is, without a database involved.  Steps I have taken to resolve the problem: Disabled 'Friendly Errors'; Made the entire inetpub directory not-Read-Only; (though it keeps reverting to 'Read Only')  Set Security Permissions as Owner for everybody; One final note, if there are any security concerns regarding the workaround, they aren't really relevant because the website is to be viewed offline and security does not play a role in the grade whatsoever - so you might as well make it a security nightmare!  I would appreciate any sort of help or hints on how to solve this problem. I don't need help with the project itself, in case you're wondering, and this is purely a technical clause that prevents me from working on the website at home. Tal

• 06-01-2009, 8:20 PM

  In reply to

  lextm Joined on 10-22-2008, 4:18 AM Shanghai, PRC Posts 1,379

  Re: Problems with Access database Reply Contact I guess you place the Access database file under inetpub. This is highly not recommended on Windows Vista. You can place the whole web site under a non-system drive and try again. Also note that Access is not suitable for web applications (it is designed for client side usage mainly), so consider using SQL Server Express edition if possible. Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 06-02-2009, 10:44 AM

  In reply to

  tal92 Joined on 06-01-2009, 5:45 PM Posts 2

  Re: Problems with Access database Reply Contact  Hello Lex, thank your for your prompt reply.  Unfortunately, your suggestion doesn't seem to work - or I might have misunderstood it.  If I transfer the website to a different folder (even on a different, external drive) the database-related sections of the website are inoperative. I have checked the website again on IIS6 and it works flawlessly. Repeating the same procedure for Vista doesn't work.  On IIS6, both the database and the HTML & ASP pages are supposed to be in the same folder under inetpub. This, however, does not work on Vista as mentioned. As for your suggestion - since this is a school project, we are instructed and requested to use these methods while creating the website, and I am well aware of the fact that this is a very outdated technology. My guess is that the curriculum hasn't changed for more than 10 years, having just seen 11 year old projects written in the very same manner. Unfortunately, there isn't much I can do and I need to follow the instructions. Does anybody have any alternate suggestions?

• 06-02-2009, 7:05 PM

  In reply to

  lextm Joined on 10-22-2008, 4:18 AM Shanghai, PRC Posts 1,379

  Re: Problems with Access database Reply Contact The differences come along with the OS itself, as IIS ASP support almost unchanges these days. I found a blog post which documents a similar case, so you may try its suggestions, http://blog.stevienova.com/2007/10/16/vista-iis7-classic-asp-and-microsoft-access-how-to-get-it-working/ Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.