Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3340 > unrolled thread

AdsApplicationExit

Started by"Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca>
First post2012-04-17 20:09 -0700
Last post2012-04-26 21:19 -0700
Articles 6 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  AdsApplicationExit "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> - 2012-04-17 20:09 -0700
    Re: AdsApplicationExit D.J.W. van Kooten <public@ic2remove.this.com> - 2012-04-18 13:22 +0200
      Re: AdsApplicationExit "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> - 2012-04-18 15:50 -0700
        Re: AdsApplicationExit "richard.townsendrose" <richard.townsendrose@gmail.com> - 2012-04-22 03:03 -0700
          Re: AdsApplicationExit "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> - 2012-04-22 20:04 -0700
            Re: AdsApplicationExit "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> - 2012-04-26 21:19 -0700

#3340 — AdsApplicationExit

From"Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca>
Date2012-04-17 20:09 -0700
SubjectAdsApplicationExit
Message-ID<31268518.309.1334718574883.JavaMail.geo-discussion-forums@pbcsi9>
I have a CGI program that is called frequently and is creating multiple connections to my Advantage Server.  

I am considering using AdsApplicationExit() as the CGI exits to try to force the connection to close. 

I would like to hear from anyone on the list who has used Advantage with a CGI as to whether this is a good idea. 

Thanks in advance for any advice.

[toc] | [next] | [standalone]


#3344

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2012-04-18 13:22 +0200
Message-ID<5n8to719dmevcvnp9hlt35s26pv0vi2e14@4ax.com>
In reply to#3340
On Tue, 17 Apr 2012 20:09:34 -0700 (PDT), "Glenn.Keeler@kingsu.ca"
<Glenn.Keeler@kingsu.ca> wrote:

Hello Glenn,

>I have a CGI program that is called frequently and is creating multiple connections to my Advantage Server.  
>
>I am considering using AdsApplicationExit() as the CGI exits to try to force the connection to close. 
>
>I would like to hear from anyone on the list who has used Advantage with a CGI as to whether this is a good idea. 
>
>Thanks in advance for any advice.

Do you have ADS installed on the (web)server where your CGI program is
running? Or do you call an ADS database on another server?

We've experimented with the fist one but did notice performance
issues, contrary to ADS installed as part of our Windows programs. Our
client, who is very happy with ADS within our program, then decided
that I should remotely access his website database using MySQL over
ODBC. To my surprise this turned out to be fast and efficient. Only
filling an overview with 10.000's of reecords (over internet of
course) takes some time, understandably.

I have not tried AdsApplicationExit.

Dick

[toc] | [prev] | [next] | [standalone]


#3351

From"Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca>
Date2012-04-18 15:50 -0700
Message-ID<32185268.1214.1334789424161.JavaMail.geo-discussion-forums@pbjk8>
In reply to#3344
On Wednesday, April 18, 2012 5:22:06 AM UTC-6, D. J. W. van Kooten wrote:

> Do you have ADS installed on the (web)server where your CGI program is
> running? Or do you call an ADS database on another server?

ADS is on a different server. The intent is to isolate data from a machine that is accessible through our firewalls, and to divide the different types of server load.

[toc] | [prev] | [next] | [standalone]


#3360

From"richard.townsendrose" <richard.townsendrose@gmail.com>
Date2012-04-22 03:03 -0700
Message-ID<c406a7be-9a17-485f-b2e4-6580397673dc@c4g2000yqj.googlegroups.com>
In reply to#3351
Glenn

We have been using AdsApplicationExit for many years

seems like - from this comment // ARG121999 it was 12th december 1999
when adriano was overhauling tdoc is vo 1 !

however, in wondows 7, IF no data table has been opened i suspect that
ads is somehow causing an unexplained crash ...

Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	TDOC_CR.exe
  Application Version:	5.11.7.0
  Application Timestamp:	00000000
  Fault Module Name:	ntdll.dll
  Fault Module Version:	6.1.7600.16559
  Fault Module Timestamp:	4ba9b29c
  Exception Code:	c0000005
  Exception Offset:	00033513
  OS Version:	6.1.7600.2.0.0.256.48
  Locale ID:	2057
  Additional Information 1:	fdaa
  Additional Information 2:	fdaaf2b7d6741980f2b4cac5ced49a42
  Additional Information 3:	1156
  Additional Information 4:	1156bbc2af577ffd5d58fe153d72dc09

but testing is very difficult because it does NOT happen when running
from the repo.

and it is not always the same message and cause - sometimes its a VO
dll, and sometimes a windows one ...

richard

[toc] | [prev] | [next] | [standalone]


#3363

From"Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca>
Date2012-04-22 20:04 -0700
Message-ID<6518422.928.1335150256430.JavaMail.geo-discussion-forums@pbcqs8>
In reply to#3360
On Sunday, April 22, 2012 4:03:58 AM UTC-6, richard.townsendrose wrote:
> Glenn

> We have been using AdsApplicationExit for many years
> 
> seems like - from this comment // ARG121999 it was 12th december 1999
> when adriano was overhauling tdoc is vo 1 !
> 
> however, in wondows 7, IF no data table has been opened i suspect that
> ads is somehow causing an unexplained crash ...

Thanks Richard. In theory this should not be an issue for me as the CGI is running under Windows Server (of various versions) but since troubleshooting runtime errors in CGIs is difficult your experience does give me pause.

It would seem, however, that as long as I ensure that at least one table has been opened this should be safe to use.

Thanks for the benefit of your experience.

[toc] | [prev] | [next] | [standalone]


#3378

From"Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca>
Date2012-04-26 21:19 -0700
Message-ID<19521080.855.1335500368467.JavaMail.geo-discussion-forums@pbqv7>
In reply to#3363
On Sunday, April 22, 2012 9:04:16 PM UTC-6, Glenn....@kingsu.ca wrote:

> Thanks Richard. In theory this should not be an issue for me as the CGI is running under Windows Server (of various versions) but since troubleshooting runtime errors in CGIs is difficult your experience does give me pause.

To follow this up, my CGIs now work much better in terms of releasing ADS connections. 

However, regardless of whether I have opened a table or not, AdsApplicationExit() makes my apps running under Windows 7 crash. The crash report is misleading in that it points to an error in the CAVO runtime dll, but that is clearly not the actual location of the error.

So my original issue is solved. It would be interesting to learn if someone has a suggested solution to the Win7 problem.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web