TAdoconnection component causes crash in my CGI webapp

From: Peter (pvdacker_at_N0_SPAM_home.nl)
Date: 03/18/05


Date: Fri, 18 Mar 2005 17:36:50 +0100

Hello all,

Using D7 and SQL2000 and IIS5
This code works fine and get Response from my CGI App:

unit Unit1;

interface

uses
  SysUtils, Classes, HTTPApp;

type
  TWebModule1 = class(TWebModule)
        procedure WebModule1webMainAction(Sender: TObject; Request:
TWebRequest;
      Response: TWebResponse; var Handled: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  WebModule1: TWebModule1;

implementation

{$R *.dfm}

procedure TWebModule1.WebModule1webMainAction(Sender: TObject;
  Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
begin
  Response.Content := 'Delphi 7';
end;

end.

But when I just simply drop a TADOConnection on my TWebModule and then after
compile I want to call the same CGI app (no properties changed like
connectionstring or so) my CGI App fails ????
A normal application with a TADOConnection works fine and I get it also
connected to my MsSQL2000 database(which is on a another server)

What could be wrong ?

Thanks
Peter.