Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3340 > unrolled thread
| Started by | "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> |
|---|---|
| First post | 2012-04-17 20:09 -0700 |
| Last post | 2012-04-26 21:19 -0700 |
| Articles | 6 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> |
|---|---|
| Date | 2012-04-17 20:09 -0700 |
| Subject | AdsApplicationExit |
| 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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2012-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]
| From | "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> |
|---|---|
| Date | 2012-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]
| From | "richard.townsendrose" <richard.townsendrose@gmail.com> |
|---|---|
| Date | 2012-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]
| From | "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> |
|---|---|
| Date | 2012-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]
| From | "Glenn.Keeler@kingsu.ca" <Glenn.Keeler@kingsu.ca> |
|---|---|
| Date | 2012-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