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.

ADS vs FoxPro 2.5

3 posts in FoxPro Last posting was on 2004-03-17 18:02:11.0Z
Tom Hahn Posted on 2004-03-09 04:27:13.0Z
From: "Tom Hahn" <thahn@hahntech.com>
Newsgroups: Advantage.FoxPro
Subject: ADS vs FoxPro 2.5
Date: Mon, 8 Mar 2004 23:27:13 -0500
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 69.136.78.229
Message-ID: <404d4936@solutions.advantagedatabase.com>
X-Trace: 8 Mar 2004 21:33:58 -0700, 69.136.78.229
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.136.78.229
Xref: solutions.advantagedatabase.com Advantage.FoxPro:174
Article PK: 1109529

I have a client with a large application written in FoxPro 2.5 (MS-DOS) that
is to be rewritten and converted to ADS (Delphi 7), with the new database
likely being in ADT format. Initially, this will be Local Server; eventually
moving to Database Server.

Because of the size of the application, the migration will happen in stages.
It is likely that both new and old applications could be accessing the same
DBF tables at some stages of the migration. My concern is about the two
applications sharing tables and the possibility for corruption.

I would appreciate any suggestions about how to handle this and any steps
that could be taken to minimize problems.

Regards,
Tom


Chris Franz [ESI] Posted on 2004-03-17 16:23:48.0Z
From: "Chris Franz [ESI]" <chris.franz@extendedsystems.com>
Newsgroups: Advantage.FoxPro
References: <404d4936@solutions.advantagedatabase.com>
Subject: Re: ADS vs FoxPro 2.5
Date: Wed, 17 Mar 2004 09:23:48 -0700
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 204.134.216.70
Message-ID: <40587cd8@solutions.advantagedatabase.com>
X-Trace: 17 Mar 2004 09:29:12 -0700, 204.134.216.70
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!204.134.216.70
Xref: solutions.advantagedatabase.com Advantage.FoxPro:176
Article PK: 1109531

Tom,

Advantage provides a Compatability Locking mode that will allow you to
open the DBF tables with Advantage and your FoxPro application at the same
time. This should make your migration easier.

However, since Advantage is not controlling access to the tables there is
still a possibility of corruption. One way to limit the possibility of
corruption is to use Propriatory Locking on all the DBF files that do not
need to be shared. You should also try to keep all the data local on the
client to reduce the chance of the a network failure causing corruption.

Chris Franz
Extended Systems INC

"Tom Hahn" <thahn@hahntech.com> wrote in message
news:404d4936@solutions.advantagedatabase.com...
> I have a client with a large application written in FoxPro 2.5 (MS-DOS)
that
> is to be rewritten and converted to ADS (Delphi 7), with the new database
> likely being in ADT format. Initially, this will be Local Server;
eventually
> moving to Database Server.
>
> Because of the size of the application, the migration will happen in
stages.
> It is likely that both new and old applications could be accessing the
same
> DBF tables at some stages of the migration. My concern is about the two
> applications sharing tables and the possibility for corruption.
>
> I would appreciate any suggestions about how to handle this and any steps
> that could be taken to minimize problems.
>
> Regards,
> Tom
>
>


Tom Hahn Posted on 2004-03-17 18:02:11.0Z
From: "Tom Hahn" <thahn@hahntech.com>
Newsgroups: Advantage.FoxPro
References: <404d4936@solutions.advantagedatabase.com> <40587cd8@solutions.advantagedatabase.com>
Subject: Re: ADS vs FoxPro 2.5
Date: Wed, 17 Mar 2004 13:02:11 -0500
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 68.42.16.17
Message-ID: <40589420@solutions.advantagedatabase.com>
X-Trace: 17 Mar 2004 11:08:32 -0700, 68.42.16.17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.42.16.17
Xref: solutions.advantagedatabase.com Advantage.FoxPro:177
Article PK: 1109532


> Advantage provides a Compatability Locking mode that will allow you to
> open the DBF tables with Advantage and your FoxPro application at the same
> time. This should make your migration easier.
>
> However, since Advantage is not controlling access to the tables there
is
> still a possibility of corruption. One way to limit the possibility of
> corruption is to use Propriatory Locking on all the DBF files that do not
> need to be shared. You should also try to keep all the data local on the
> client to reduce the chance of the a network failure causing corruption.
>
> Chris Franz
> Extended Systems INC

Thank you for the suggestions.

Tom