Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Strange behaviour

6 posts in NT Last posting was on 2009-08-28 16:00:32.0Z
Philippe Bruno Posted on 2009-08-02 04:19:58.0Z
From: "Philippe Bruno" <philippe.bruno@something.com>
Newsgroups: Advantage.NT
Subject: Strange behaviour
Date: Sun, 2 Aug 2009 00:19:58 -0400
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 24.200.56.231
Message-ID: <4a7513bd@solutions.advantagedatabase.com>
X-Trace: 1 Aug 2009 22:19:09 -0700, 24.200.56.231
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.200.56.231
Xref: solutions.advantagedatabase.com Advantage.NT:1797
Article PK: 1130891

Hi,

I experienced a strange problem today with ADS 9.1 on a Windows 2000 Server.
An application (developed in Delphi 7 with TDataSet descendant v. 9.1) runs
fine when executed from a local drive (C:) on a Windows XP machine part of
the network. However, when the same application (same dinky test EXE opening
one table in remote mode) is ran from the server drive (H:) instead of the
local drive on the same Windows XP machine, it crashes with different
outcomes. Sometimes, it fails with error 6420 (Unable to "discover" the
Advantage Database Server), sometimes with "CoInitialize() failed" or
sometimes with the infamous "[...] has encountered a problem and needs to
close...".

As much as we will run the EXE from the hard drive of the client machines
and are (hopefully) unlikely to encounter this problem, I wish I can
understand why it is doing this... Further testing revealed that it only
happens if I try to connect to ADS in remote mode. In other words, if we
have an application with no database component, we do not experience any
problem. If we have a minimal application opening one TAdsTable in local
mode (although the tables are on the server drive), we do not experience any
problem whether we run the application from C: or from H:. Now, if we take
the same application but open the table in remote mode, it works well from
C: but crashes when the EXE is ran from H:.

Could it be an anti-virus on the server? Could it be ADS that gets confused
because the database is on the same drive as the EXE?

Thanks in advance for any thoughts you can share.

Philippe


Joachim Duerr (ADS) Posted on 2009-08-26 09:30:08.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Strange behaviour
Newsgroups: Advantage.NT
References: <4a7513bd@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4a94f290@solutions.advantagedatabase.com>
Date: 26 Aug 2009 02:30:08 -0700
X-Trace: 26 Aug 2009 02:30:08 -0700, 10.56.66.155
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.NT:1802
Article PK: 1130896


Philippe Bruno wrote:

>Could it be an anti-virus on the server? Could it be ADS that gets
>confused because the database is on the same drive as the EXE?

sure...If your database is located on H: then you need to have an ADS
running on that particular machine.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Philippe Bruno Posted on 2009-08-26 17:09:59.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.NT
References: <4a7513bd@solutions.advantagedatabase.com> <4a94f290@solutions.advantagedatabase.com>
Subject: Re: Strange behaviour
Date: Wed, 26 Aug 2009 13:09:59 -0400
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.70.67.26
Message-ID: <4a956bce@solutions.advantagedatabase.com>
X-Trace: 26 Aug 2009 11:07:26 -0700, 69.70.67.26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.70.67.26
Xref: solutions.advantagedatabase.com Advantage.NT:1804
Article PK: 1130899

Joachim,

Well, obviously we have ADS installed on the server. Perhpas, I was not
clear in my explanation...

[XP SP3 Machine] <---->[Windows 2003 Server]

ADS and databse on W2003 machine (drive D:) mapped as drive H: on XP
machine. Drive C:, is local to XP machine.

Philippe

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> a écrit dans le message de news:
4a94f290@solutions.advantagedatabase.com...

> Philippe Bruno wrote:
>
>>Could it be an anti-virus on the server? Could it be ADS that gets
>>confused because the database is on the same drive as the EXE?
>
> sure...If your database is located on H: then you need to have an ADS
> running on that particular machine.
>
> --
> Joachim Duerr
> Advantage Presales
> check out my new ADS book on http://www.jd-engineering.de/adsbuch


Joachim Duerr (ADS) Posted on 2009-08-26 22:01:38.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Strange behaviour
Newsgroups: Advantage.NT
References: <4a7513bd@solutions.advantagedatabase.com> <4a94f290@solutions.advantagedatabase.com> <4a956bce@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 84.158.160.205
Message-ID: <4a95a2b2@solutions.advantagedatabase.com>
Date: 26 Aug 2009 15:01:38 -0700
X-Trace: 26 Aug 2009 15:01:38 -0700, 84.158.160.205
Lines: 17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.160.205
Xref: solutions.advantagedatabase.com Advantage.NT:1805
Article PK: 1130903


Philippe Bruno wrote:

>Well, obviously we have ADS installed on the server. Perhpas, I was
>not clear in my explanation...
>
>[XP SP3 Machine] <---->[Windows 2003 Server]
>
>ADS and databse on W2003 machine (drive D:) mapped as drive H: on XP
>machine. Drive C:, is local to XP machine.

does it work when your application is local on the XP machine, but
connects to the database located on H?

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Philippe Bruno Posted on 2009-08-27 21:54:18.0Z
From: "Philippe Bruno" <pbruno@deveauxbrault.com>
Newsgroups: Advantage.NT
References: <4a7513bd@solutions.advantagedatabase.com> <4a94f290@solutions.advantagedatabase.com> <4a956bce@solutions.advantagedatabase.com> <4a95a2b2@solutions.advantagedatabase.com>
Subject: Re: Strange behaviour
Date: Thu, 27 Aug 2009 17:54:18 -0400
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.70.67.26
Message-ID: <4a96ff22@solutions.advantagedatabase.com>
X-Trace: 27 Aug 2009 15:48:18 -0700, 69.70.67.26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.70.67.26
Xref: solutions.advantagedatabase.com Advantage.NT:1806
Article PK: 1130900

Joachim,

Yes, indeed, it works well this way. So in summary, it only bombs when the
EXE is ran from the server. Mind you, when the program is finished, we will
deploy it on each machine and not run it from the server, but it is
nevertheless a strange case.

Thanks for looking into that...

Philippe


"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> a écrit dans le message de news:
4a95a2b2@solutions.advantagedatabase.com...

> Philippe Bruno wrote:
>
>>Well, obviously we have ADS installed on the server. Perhpas, I was
>>not clear in my explanation...
>>
>>[XP SP3 Machine] <---->[Windows 2003 Server]
>>
>>ADS and databse on W2003 machine (drive D:) mapped as drive H: on XP
>>machine. Drive C:, is local to XP machine.
>
> does it work when your application is local on the XP machine, but
> connects to the database located on H?
>
> --
> Joachim Duerr
> Advantage Presales
> check out my new ADS book on http://www.jd-engineering.de/adsbuch


Mark Wilkins Posted on 2009-08-28 16:00:32.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.NT
References: <4a7513bd@solutions.advantagedatabase.com> <4a94f290@solutions.advantagedatabase.com> <4a956bce@solutions.advantagedatabase.com> <4a95a2b2@solutions.advantagedatabase.com> <4a96ff22@solutions.advantagedatabase.com>
Subject: Re: Strange behaviour
Date: Fri, 28 Aug 2009 10:00:32 -0600
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.228
Message-ID: <4a97fed4@solutions.advantagedatabase.com>
X-Trace: 28 Aug 2009 09:59:16 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.NT:1807
Article PK: 1130901

Hi Philippe,

What is the connection path that you are using? It sounds like maybe you
are using a different connection path based on the location of the
application when it starts. Another thing to check is to see if there is
possibly an ads.ini in the application directory when it runs. Maybe there
is one on h: but not on c: in your testing. That could cause a difference
such as this.

Mark Wilkins
Advantage R&D

"Philippe Bruno" <pbruno@deveauxbrault.com> wrote in message
news:4a96ff22@solutions.advantagedatabase.com...
> Joachim,
>
> Yes, indeed, it works well this way. So in summary, it only bombs when the
> EXE is ran from the server. Mind you, when the program is finished, we
> will deploy it on each machine and not run it from the server, but it is
> nevertheless a strange case.
>
> Thanks for looking into that...
>
> Philippe
>