stuck cgi application using Ado with windows 2003 + II6

From: Maurizio Ferreira (maurizio.ferreira_at_selesta.it)
Date: 02/24/04

  • Next message: Figaro: "Re: Unknown Error has Occured"
    Date: Tue, 24 Feb 2004 11:40:39 +0100
    
    

    A simple cgi program written in delphi opens an Access table and gets
    the number of records.
    I'm testing this program on a windows 2003 server with II6 installed.

    If I start this application from the command prompt it works
    correctly.
    If I use a simple web server (Abyss Web Server) and I start it
    from a html page, it works correctly.

    If I use II6 as web server, the application get stuck and the browser
    exits with a time-out.

    Note 1 : the application get stuck trying to connect to the database.
    no exceptions

    Note 2 : I've tried to use an sql server instead of an access table:
    same results.

    Note 3 : The same program works correctly on windows 2000 + IIS 5

    It seems the combination of windows 20003 + II6 + ADO

    this is the meaningflup part of my program :

    procedure TWebModule1.WebModule1myactionAction(Sender: TObject;
    Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
    begin
      try
        work (response);
      except
        on e:exception do begin
          response.Content := '<html><body>' + 'error : ' + e.message +
    '</body></html>';
          exit;
        end;
      end;
    end;

    procedure TWebModule1.work (Response: TWebResponse);
    var n : integer;
    begin
      with tbl1 do begin
        open;
        n := recordcount;
        close;
        response.Content := '<html><body> there are ' + inttostr(n) + '
    records in the table </body></html>';
      end;
    end;

    Any suggestion ?

    Raegard
    Maurizio


  • Next message: Figaro: "Re: Unknown Error has Occured"

    Relevant Pages

    • Re: VB.NET, multiple entries into web based VB.NET app
      ... When user clicks on the submit button multiple times, ... the process was slow and user thinks it's stuck. ... > I have all of the controls located on the server, ... > web server. ...
      (microsoft.public.dotnet.general)
    • Re: write with cURL
      ... execute permissions. ... This is assuming that the PHP script runs ... of potential security risks from other users on the same server. ... web server itself is part of the group. ...
      (alt.php)
    • Re: web service architecture question
      ... To assume that we have all the security we will ever need is a bad one. ... ways to breach a server, and the separatin of the web and app server is one ... You can use remoting or web services. ... The web server will be exposed outside the ...
      (microsoft.public.dotnet.framework.webservices)
    • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
      ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
      (microsoft.public.dotnet.languages.vb)
    • RE: System.Data.SqlClient "Timeout expired" causing ASP.net web applic
      ... There are many values here that can shutdown the aspnet_wp. ... > update tables on a Web Server running SQL Server 2000. ... > formation(DataSet currentBalances): Timeout expired. ...
      (microsoft.public.dotnet.framework.aspnet)