Search results matching tags 'ASP Classic' and 'IIS 7'

Problem with ASP code in IIS7: DBNULL

Jwoodger — Thu, 22 Oct 2009 02:53:27 GMT

When I run my web application on Windows 2003 IIS 6, my site runs perfectly. It however has certain issues when migrated to Windows 2008 IIS 7 - sometimes I get errors with converting/casting dbnull to strings. Is there some configuration that can be used to emulate the older way of handling such values?

odbc connection pooling with Delphi 7 & IIS7

ffsetit — Mon, 05 Oct 2009 08:04:19 GMT

We have a application that utilizes a combination of ASP.net (c#) and classic ASP (Delphi 7). When running the application on Windows Vista or Server 2008 using IIS7 we experience terrible performance problems from the classic ASP pages when retrieving data from SQL. Upon investigation using SQL Profiler it is apparent that hard connections are being opened and closed rather than being pooled. We experience the same issue with IIS6 on Server 2003 however this can be worked around by enabling IIS5.0 compatibility mode. Unfortunately there seems to be no such workaround for IIS7 Does anyone have any ideas as to why odbc connection pooling does not work in IIS7 (or 6)

Blank Page No Errors

goofy_tyran — Wed, 16 Sep 2009 14:59:19 GMT

Hi guys,

I have a website which I've brought over to IIS7 from Windows IIS6, which ran great there.

Now its on IIS7 some of my Classic ASP pages wont run and simply stop dead outputting to the browser just a blank page. The only thing in the blank page source code are the usual <html> tags etc. There are no error codes at all.

If I break the code (by adding a 'end if' in to the code where it sholdnt be) I get the relevant errors.

This happens to only a handful of pages. The only common thing I can see between the pages is that they use the 'Server.CreateObject' call to either create an instance of Jmail or FileSystemObject.

I'm really stumped with this one and any help would be would be greatfully received.

Thanks in advance!

ASP Classic, IIS 7, SQL 2005, and Windows Authentication Problem

thig95 — Thu, 04 Jun 2009 13:53:12 GMT

I have recently migrated an application written in ASP classic to a server running IIS 7 (64bit) on Server 2008 Standard. I have IIS 6 compatibility installed, as well as basic and windows authentication modules. This server is part of a corporate domain. I am trying to establish windows authentication to this web server as well as a SQL 2005 server also running on Server 2008. My desire is to use windows authentication to the db server, and this is where my problem lies.

For more details, I have setup a custom site called CRM. This site has it's own application pool also called CRM. I have configured the application pool identity to use my domain account (for testing purposes since i know my account has rights to the db i'm trying to connect to.) When I enable windows authentication, I am able to successfully logon to the site and its ASP pages, however when calls to the db are made (using ADO) I get

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

So from this I assume even though i'm using my domain logon as the worker process identity, those credentials aren't simply passed when making calls to other resources on the network. Is there a way to do that? My end goal is to have users get into the site without having to type their credentials, and have their domain account provide access to the db rather than having to setup a generic sql login and use that in my connection string.

Clearly from the above error I am using OLEDB but I have also tried to set this up using a DSN connection via ODBC. Both resulted in the same error. So this doesn't seem to be a SQL problem, rather how credentials are being passed to sql from IIS. This setup will work if I use basic authentication, since it then just stores the id and password in cleartext. But I don't want to go that route for obvious reasons.

Any help would be greatly appreciated! I've found a slew of documentation on this for .NET, but i'm not about to rewrite my whole app just to get authentication working properly.

Folders without the use of trailing /

RobUK — Wed, 29 Apr 2009 11:51:05 GMT

Hi,

I wonder if anyone can help, we have just migrated our systems from IIS5 (W2K) over to windows 2008, we have had a couple of problems, most of which we have sorted. The last problem we are having is to do with the way in which IIS7 treats folders.

Previously i could browse to http://sitename/folder and the default.asp within that folder would work. Now i have to go to http://sitename/folder/ in order to achive the same thing. This may sould trivial but this is causing us some problems.

Does anyone know of a workaround for this? I have try searching but it's difficult to know what to search for.... hence my post...... i'll continue googling (with my fingers corssed that someone out there can help!)

Thanks

Rob

IIS7 and VB runtime access denied

HercG — Tue, 13 Jan 2009 05:11:10 GMT

I hae a problem with a Web site effectively written as a VB6-style IIS application, i.e. the app itself is a VB6-generated DLL. This works perfectly in all 32-bit versions of Windows, but fails on Vista 64-bit running IIS7. The specific error is an access-denied message, and it seems to be the VB runtime module to which access is denied.

A solution seemed to be to grant access rights to the file to the anonymous user, which is no longer included in the Everyone group and is now called "Anonymous Logon", not IUSR_<machine name> as it used to be. However, I found that even with an Administrator logon with elevated privilege I could not change the access rights to the VB runtime.

The document http://msdn.microsoft.com/en-us/vbrun/ms788708.aspx (title “Support Statement for Visual Basic 6.0 on Windows®Vista™and Windows®Server 2008 ™”) contains the following:

"64-Bit Windows

"Visual Basic 6.0 runtime files are 32-bit. These files ship in 64-bit Windows Operating Systems referenced in the table below. 32-bit VB6 applications and components are supported in the WOW emulation environment only. 32-bit components must also be hosted in 32-bit application processes."

If I am interpreting this correctly, it means that 32-bit components cannot be run under IIS7 on a 64-bit platform, since IIS is presumably not running in WOW emulation mode. Does anyone know if this is definitely the case, or is there some way to run this sort of scenario?

Issues in IIS 7, session and application variables are not maintained - Classic ASP site

shamshad.ali@softechww.com — Tue, 02 Dec 2008 14:57:21 GMT

For local development purpose, I ran following script on VISTA, IIS 7:

<%
for each x in Request.ServerVariables
response.write("<b>" & x & ":</b>   " & Request.ServerVariables(x) & "<br><BR>")
next
%>

It does not show me IP of client, Request.ServerVariables("remote_host") and

(Request.ServerVariables("remote_addr").

on my vista I had IPv 6 and IPv4 both enabled. i dropped IPv6 protocole and now Request.ServerVariables("remote_host") is showing ::1 value earlier it was showing "A6073E5A-D779-472A-8430-9B03999E4121" AS IP

Also I noticed that all values assigned to session and application variables defined in global.asa are not available in other pages of my website means session and application variables are not maintaining. It seems that whole server side variables are not working that were initialized with appliction_OnStart, session_OnStart. Wherein whole ASP siter with no change in code is working fine with IIS 6 (xp/win2k3). But this issues comes within IIS 7. Please help how this can be fixed ?

Shamshad Ali

Sessions Failing Using Classic ASP After Switch to IIS 7

sjc_atx — Wed, 22 Oct 2008 00:07:41 GMT

Please help. I recently upgraded to IIS 7. A site I was working on which use sessions (and worked fine when I had IIS 6) no longer works. I have set up a simple test page in the site root to write a variable and another to retrieve it. It fails. However, if I set the session variable in my global.asa file, I can retrieve it.

In IIS 7, I have Session States set to "In Process" and "Use Cookies". IUSR has Full Control Permissions.

Thoughts? Any help would be appreciated.

Web Garden IIS 7 Classic ASP

znwpta — Wed, 17 Sep 2008 14:45:53 GMT

I am currently upgrading our web server from 2003 to 2008, we use Classic ASP. I have been using IIS7 w/o major problems until I tried to use the State Server under "Session " Icon. I have it set to ConecctionString = "10.0.10.9:424249". It does not seem like the state server works for classic ASP, since I am losing my session at random times. Is there a way to use a state server in IIS 7 for classic ASP ?

reading Active Directory groups no longer works in IIS7

ChrisRh — Thu, 03 Jul 2008 17:45:15 GMT

This classic ASP code worked in IIS 6, but not in IIS7. It was a great way for me to check an authenticated username against an AD group membership list to give certain options on pages. Does anyone have a suggestion for a replacement (other than hard-coding usernames)?

    username_found_sw = "N"
    Set oGroup = GetObject("WinNT://domain/its_staff")
    For Each oMember in oGroup.Members
     If Ucase(trim(oMember.Name)) = trim(Session("username")) Then
     username_found_sw = "Y"
     End If
    Next
    Set oGroup = Nothing