Home > Forums › 64-bit Editions of IIS › IIS in SySWoW Mode › Classic ASP, Access & ODBC

Thread: Classic ASP, Access & ODBC

Last post 08-17-2009 3:03 PM by dcgmbh. 8 replies.

Average Rating Rate It (5)Thank you for the rating!

RSS

Page 1 of 1 (9 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

07-28-2009, 2:38 AM

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Classic ASP, Access & ODBC

Reply Contact

Hello,
my goal is to get a access database running with ASP on a MS SBS 2008.
(Everything worked on SBS 2003)

What works:

32 ODBC and UDL file (connection to the access via ODBC32 OK)
ASP Classic (64bit application pool)

Problem:

changing to 32-Bit_Application in the Application Pool stops the service and I get a http error 503
No ASP anymore

I thought I have to switch to 32 bit applic. to use the 32 ODBC?
I use Identity LocalSystem and tried this on the server browser.

Any idea?

Thanks!

08-12-2009, 1:17 AM In reply to

davcox
Joined on 07-21-2006, 2:28 PM
Redmond
Posts 213

Re: Classic ASP, Access & ODBC

Reply Contact

Can you clarify if you're using a 64bit OS?

Certain parts of ODBC are only available in 32bit ... wikipedia has a good article here on the support they provided: http://en.wikipedia.org/wiki/Microsoft_Data_Access_Components

Dave

08-15-2009, 12:42 AM In reply to

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Re: Classic ASP, Access & ODBC

Reply Contact

Yes, I am using 64bit OS (SBS 2008 comes only with 64bit, because of MS Exchange 2007).

When I use the test with the UDL file on the server, it works ... access via 32bit ODBC to Access 2003 works.

It seems to be more a problem of the IIS in connection with classic ASP

When I set the application pool to 32 bit mode enable, the application pool stops.

The system log files says that the appl.pool ist stoppef because of a series of errors. (Event ID 5002, Source WAS) and warnings like Error in the listening canal for http (event id 5139 in WAS)

Tags: IIS7 ODBC 32 ASP Classic

08-15-2009, 1:24 AM In reply to

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Re: Classic ASP, Access & ODBC

Reply Contact

This looks like a similar problem, http://forums.iis.net/t/1157092.aspx, but in my case it is not a dll.

I just retested - same error. What I did:

additional ip 10.0.0.6
new "testweb" with the ip 10.0.0.6
2 files into the folder testweb (test.htm (response text "test"), test.asp (<% response.write now() %>
test.asp and test.htm WORK
Application Pool: testweb - "32-Bit-Anwendungen aktivieren" change to True (german sbs 2008, set application to 32 bit) --> test.asp and test.htm do not work anymore and the application pool is stopped (HTTP Error 503. The service is unavailable.)
System Event ID: Warning 5 x 5139 (source WAS) and Error 5002

... anybody same problem, idea?

Tags: IIS7 32 bit WAS

08-17-2009, 2:16 AM In reply to

davcox
Joined on 07-21-2006, 2:28 PM
Redmond
Posts 213

Re: Classic ASP, Access & ODBC

Reply Contact

Given that switching the "bitness" of your application pool causes your problems, there's a couple reasons why that could be happening:

1) you have some ISAPI or module installed that does not have it's bitness specified properly in the configuration

2) you're attempting to load some 64bit-only code into your 32bit process (when you do the bitness switch) ... you may need to update your code to reference the right bitness of the DLL you're working with depending on the bitness of the application pool

You're getting the event log errors because the application pool is crashing due to some problem (which I'm guessing is one of the above).

Dave

08-17-2009, 2:31 AM In reply to

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Re: Classic ASP, Access & ODBC

Reply Contact

... I will search for the 64-bit code, but I guess I will not have much luck. I will try to setup the debugger tools ...

The Server is a clean new installation of Microsoft Small Business Server 2008 (german). No additional programs are installed. I guess it must be the SBS2008. Maybe I try on W2008 too. This is on my clean new test-system on my virtual machine. Excactly the same is setup on my customer server - same problem. No DLL or appl. installed yet.

The only code/application I have is:

test.asp (works in 64bit mode)
<% response.write now() %>

test.html
<html><body>test</body></html>

WEB.CONFIG (works in 64bit mode)
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <security>
            <authentication>
                <windowsAuthentication enabled="true" />
            </authentication>
        </security>
    </system.webServer>
</configuration>

08-17-2009, 3:44 AM In reply to

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Re: Classic ASP, Access & ODBC

Reply Contact

FYI:

I tested this on a WINDOWS 2008 server now (problem, my customer has a SBS2008 server I have to use).

Here the example above works without a problem! (Switching 32bit <-> 64bit OK)

I compared the application pool settings of the SBS2008 server and the W2008 server and they are identical.

08-17-2009, 1:30 PM In reply to

anilr
Joined on 05-23-2006, 6:13 PM
Redmond, WA
Posts 2,343

Re: Classic ASP, Access & ODBC

Reply Contact

Small business server is a beast with multiple applications pre-installed and pre-configured and I have seen many issues reported with people trying to use other applications on this sku because of interaction with the pre-installed components - eg, a few components like rpc/http and WSUS do not work (and in some cases break other apps) when IIS is configured to run in 32-bit mode.

Are you seeing any errors/warnings in the application event log when the application pool gets stopped?

Anil Ruia
Senior Software Design Engineer
IIS Core Server

08-17-2009, 3:03 PM In reply to

dcgmbh
Joined on 07-28-2009, 2:32 AM
Posts 7

Re: Classic ASP, Access & ODBC

Reply Contact

Hello,
I found now the following error now (did not see it before) - I guess should take a look at this:
http://forums.iis.net/p/1151288/1877461.aspx

Protokollname: Application
Quelle:        Microsoft-Windows-IIS-W3SVC-WP
Datum:         17.08.2009 20:52:29
Ereignis-ID:   2280
Aufgabenkategorie:Keine
Ebene:         Fehler
Schlüsselwörter:Klassisch
Benutzer:      Nicht zutreffend
Computer:      AERYN.dcnet.local
Beschreibung:
Fehler beim Laden der Modul-DLL C:\Windows\system32\RpcProxy\RpcProxy.dll. Die Daten enthalten Fehlerinformationen.
Ereignis-XML:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Microsoft-Windows-IIS-W3SVC-WP" Guid="{670080D9-742A-4187-8D16-41143D1290BD}" EventSourceName="W3SVC-WP" />
    <EventID Qualifiers="49152">2280</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-08-17T18:52:29.000Z" />
    <EventRecordID>286879</EventRecordID>
    <Correlation />
    <Execution ProcessID="0" ThreadID="0" />
    <Channel>Application</Channel>
    <Computer>AERYN.dcnet.local</Computer>
    <Security />
</System>
<EventData>
    <Data Name="ModuleDll">C:\Windows\system32\RpcProxy\RpcProxy.dll</Data>
    <Binary>7E000000</Binary>
</EventData>
</Event>

Page 1 of 1 (9 items)