server application

Vlamir Alves

Delphi Developer

Sun, 27 Jun 2004 03:57:05 GMT

Mixing and losing records in Paradox Tables on a Client/server application

HI !
I have a client/server application using Paradox Tables and some times records are mixed or even lost after posting them in different clients at the same time.
I even have tested using the application on the server only, and
sometime, a record is lost after post.
My BDE administrator configurations IN ALL CLIENTS AND ALSO IN SERVER are:

DRIVERS:
NET DIR = s:\test (where S is the mapped C server hard disk)
VERSION = 3.0
LANGDRIVE = PARADOX 'ASCII'
BLOCK SIZE = 4096

SYSTEM:
DEFAULT DRIVER = PARADOX
LOCAL SHARE = TRUE
MAXBUFSIZE = 4096
MAXFILEHANDLES = 48
SHAREDMENLOCATION =
SHAREDMENSIZE = 4096

my server is a WIN NT 4.O service pack 6 and clients are WIN 95 or WIN 98.

Thanks in advance !

Vlamir

Sundial Service

Delphi Developer

Sun, 27 Jun 2004 04:47:16 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

You may be dealing with BDE cache issues that have been discussed here
at great length.

Use google (http://groups.google.com) to search for the keys
"dbiSaveChanges" and "dbiUseIdleTime" in "*delphi*" groups...

Quote

Vlamir Alves wrote:

> HI !
> I have a client/server application using Paradox Tables and some times records are mixed or even lost after posting them in different clients at the same time.
> I even have tested using the application on the server only, and
> sometime, a record is lost after post.
> My BDE administrator configurations IN ALL CLIENTS AND ALSO IN SERVER are:

> DRIVERS:
> NET DIR = s:\test (where S is the mapped C server hard disk)
> VERSION = 3.0
> LANGDRIVE = PARADOX 'ASCII'
> BLOCK SIZE = 4096

> SYSTEM:
> DEFAULT DRIVER = PARADOX
> LOCAL SHARE = TRUE
> MAXBUFSIZE = 4096
> MAXFILEHANDLES = 48
> SHAREDMENLOCATION =
> SHAREDMENSIZE = 4096

> my server is a WIN NT 4.O service pack 6 and clients are WIN 95 or WIN 98.

> Thanks in advance !

> Vlamir

--
----------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com (PGP public key available.)

- Show quoted text -

Quote

> Fast(!), automatic table-repair with two clicks of the mouse!
> ChimneySweep(R): Release 4.0 is here!!
> http://www.sundialservices.com/products/chimneysweep

Team

Delphi Developer

Sun, 27 Jun 2004 09:26:52 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

Take a look at http://community.borland.com/article/0,1410,15209,00.html .

--
Bill
(TeamB cannot answer questions received via email)

Brian Bushay Team

Delphi Developer

Sun, 27 Jun 2004 11:32:11 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

Quote

>I have a client/server application using Paradox Tables and some times records are mixed or even lost after posting them in different clients at the same time.
>I even have tested using the application on the server only, and
>sometime, a record is lost after post.
>My BDE administrator configurations IN ALL CLIENTS AND ALSO IN SERVER are:

I suggest you test the tables for Corruption with Tutility.

Download Tutility
http://www.borland.com/devsupport/bde/utilities.html

Other 3rd party table repair utilities.

PdxRbld www.rksolution.cz/delphi/delphi.htm

DataSentry Data Maintenance Utility -- free, full
featured trial available for download at http://www.logicprocess.com.

"Out And About's" TUtility VCL components - a pretty smooth
interface to TUtil*.dll for budget bucks.
You'll find them at www.o2a.com

http://www.bpsoftware.com/products/tbu.htm, which is B&P
Table Utilities. The latest release of this product has been released, it
now includes the ability to save a tables structure to text file.

ChimneySweep from Sundial Services provides batched (scripted) table
repair/maintenance for the all the tables in a database does not use Tutility.
http://www.sundialservices.com/ )
http://www.sundialservices.com/cs3web.htm
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Vlami

Delphi Developer

Sun, 04 Jul 2004 04:24:45 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

"Bill Todd $TeamB$" <f...@foo.com> wrote:

Quote

>Take a look at http://community.borland.com/article/0,1410,15209,00.html .

>--
>Bill
>(TeamB cannot answer questions received via email)

I followed the tips described on the article, but one problem remains:
if I try to append 2 records on the same table at the same time, one through a W95 machine and the other using the WIN NT 4 server (SP6) - where the tables are stored -, the record inserted by the NT SERVER disappeared, although the append process didnt report an error.
I repeat the test using 2 W95 macinhes accessing the tables on the server, and everything work fine. If I put tables on the W95 machine and repeat the prior test, everything work fine too.

Could you help me?
Thanks in advance

Vlamir

Team

Delphi Developer

Sun, 04 Jul 2004 04:56:51 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

It sounds like the BDE on the server is not configured with Local Share on.
See http://community.borland.com/article/0,1410,15247,00.html for details.

--
Bill
(TeamB cannot answer questions received via email)

Quote

"Vlamir" <val...@brasimac.com.br> wrote in message

news:3c44900d$1_2@dnews...

Quote

> "Bill Todd $TeamB$" <f...@foo.com> wrote:
> >Take a look at http://community.borland.com/article/0,1410,15209,00.html
.

> >--
> >Bill
> >(TeamB cannot answer questions received via email)

> I followed the tips described on the article, but one problem remains:
> if I try to append 2 records on the same table at the same time, one

through a W95 machine and the other using the WIN NT 4 server (SP6) - where
the tables are stored -, the record inserted by the NT SERVER disappeared,
although the append process didnt report an error.

Quote

> I repeat the test using 2 W95 macinhes accessing the tables on the server,

and everything work fine. If I put tables on the W95 machine and repeat the
prior test, everything work fine too.

Quote

> Could you help me?
> Thanks in advance

> Vlamir

Vlami

Delphi Developer

Mon, 05 Jul 2004 01:29:04 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

Hi !
Unfortunatelly (or fortunatelly) LOCAL SHARE on the server is set to TRUE.
I found a message in some Delphis newsgroup (I cant reproduce it to you because I lost it, but if you desire, I can find out it again) pointing that BDE/Paradox applications and WIN NT used as a client, is not a good mixing.
Can I trust in it?

Vlamir

"Bill Todd $TeamB$" <bill_nos...@dbginc.com> wrote:

Quote

>It sounds like the BDE on the server is not configured with Local Share on.
>See http://community.borland.com/article/0,1410,15247,00.html for details.

>--
>Bill
>(TeamB cannot answer questions received via email)

>"Vlamir" <val...@brasimac.com.br> wrote in message
>news:3c44900d$1_2@dnews...

>> "Bill Todd $TeamB$" <f...@foo.com> wrote:
>> >Take a look at http://community.borland.com/article/0,1410,15209,00.html
>..

>> >--
>> >Bill
>> >(TeamB cannot answer questions received via email)

>> I followed the tips described on the article, but one problem remains:
>> if I try to append 2 records on the same table at the same time, one
>through a W95 machine and the other using the WIN NT 4 server (SP6) - where
>the tables are stored -, the record inserted by the NT SERVER disappeared,
>although the append process didnt report an error.
>> I repeat the test using 2 W95 macinhes accessing the tables on the server,
>and everything work fine. If I put tables on the W95 machine and repeat the
>prior test, everything work fine too.

>> Could you help me?
>> Thanks in advance

>> Vlamir

Team

Delphi Developer

Mon, 05 Jul 2004 05:16:09 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

Are you sure that the BDE on _every_ machine is configured as described in
http://community.borland.com/article/0,1410,15247,00.html? I have not had
any problems with Paradox tables on NT servers.

--
Bill
(TeamB cannot answer questions received via email)

Quote

"Vlamir" <val...@brasimac.com.br> wrote in message news:3c45b860_1@dnews...

> Hi !
> Unfortunatelly (or fortunatelly) LOCAL SHARE on the server is set to TRUE.
> I found a message in some Delphis newsgroup (I cant reproduce it to you

because I lost it, but if you desire, I can find out it again) pointing that
BDE/Paradox applications and WIN NT used as a client, is not a good mixing.

Quote

> Can I trust in it?

> Vlamir

> "Bill Todd $TeamB$" <bill_nos...@dbginc.com> wrote:
> >It sounds like the BDE on the server is not configured with Local Share
on.
> >See http://community.borland.com/article/0,1410,15247,00.html for
details.

> >--
> >Bill
> >(TeamB cannot answer questions received via email)

> >"Vlamir" <val...@brasimac.com.br> wrote in message
> >news:3c44900d$1_2@dnews...

> >> "Bill Todd $TeamB$" <f...@foo.com> wrote:
> >> >Take a look at

http://community.borland.com/article/0,1410,15209,00.html

- Show quoted text -

Quote

> >..

> >> >--
> >> >Bill
> >> >(TeamB cannot answer questions received via email)

> >> I followed the tips described on the article, but one problem remains:
> >> if I try to append 2 records on the same table at the same time, one
> >through a W95 machine and the other using the WIN NT 4 server (SP6) -
where
> >the tables are stored -, the record inserted by the NT SERVER
disappeared,
> >although the append process didnt report an error.
> >> I repeat the test using 2 W95 macinhes accessing the tables on the
server,
> >and everything work fine. If I put tables on the W95 machine and repeat
the
> >prior test, everything work fine too.

> >> Could you help me?
> >> Thanks in advance

> >> Vlamir

Vlami

Delphi Developer

Tue, 06 Jul 2004 03:28:36 GMT

Re:Mixing and losing records in Paradox Tables on a Client/server application

Hi !
I have an application on every Start Up Folders that sets up my BDE parameters (that I reproduced in my first message).
The message that I mentioned in my last written suggests that the database has to be moved to a Win98 machine, because Win NT
could have some problems with locking.
I found in Delphi Magazine article abou Paradox File Corruption
some tips to disable caching and new file sharing and locking semantics in Win95. I didnt find anything about it related to WIN NT. Are there?

Thanks again!

Vlamir

"Bill Todd $TeamB$" <bill_nos...@dbginc.com> wrote:

Quote

>Are you sure that the BDE on _every_ machine is configured as described in
>http://community.borland.com/article/0,1410,15247,00.html? I have not had
>any problems with Paradox tables on NT servers.

>--
>Bill
>(TeamB cannot answer questions received via email)

>"Vlamir" <val...@brasimac.com.br> wrote in message news:3c45b860_1@dnews...

>> Hi !
>> Unfortunatelly (or fortunatelly) LOCAL SHARE on the server is set to TRUE.
>> I found a message in some Delphis newsgroup (I cant reproduce it to you
>because I lost it, but if you desire, I can find out it again) pointing that
>BDE/Paradox applications and WIN NT used as a client, is not a good mixing.
>> Can I trust in it?

>> Vlamir

>> "Bill Todd $TeamB$" <bill_nos...@dbginc.com> wrote:
>> >It sounds like the BDE on the server is not configured with Local Share
>on.
>> >See http://community.borland.com/article/0,1410,15247,00.html for
>details.

>> >--
>> >Bill
>> >(TeamB cannot answer questions received via email)

>> >"Vlamir" <val...@brasimac.com.br> wrote in message
>> >news:3c44900d$1_2@dnews...

>> >> "Bill Todd $TeamB$" <f...@foo.com> wrote:
>> >> >Take a look at
>http://community.borland.com/article/0,1410,15209,00.html
>> >..

>> >> >--
>> >> >Bill
>> >> >(TeamB cannot answer questions received via email)

>> >> I followed the tips described on the article, but one problem remains:
>> >> if I try to append 2 records on the same table at the same time, one
>> >through a W95 machine and the other using the WIN NT 4 server (SP6) -
>where
>> >the tables are stored -, the record inserted by the NT SERVER
>disappeared,
>> >although the append process didnt report an error.
>> >> I repeat the test using 2 W95 macinhes accessing the tables on the
>server,
>> >and everything work fine. If I put tables on the W95 machine and repeat
>the
>> >prior test, everything work fine too.

>> >> Could you help me?
>> >> Thanks in advance

>> >> Vlamir

Other Threads

1. Paradox 4.x, 5.x and 7 tables Mix with Language driver mix

2. Paradox application : losing records.

3. Losing blocks of records from linked Paradox table??!

4. Paradox records are not inserted into table permanently, abnormal shutting down makes data lost

5. Help Database: Lost records in Paradox table with no reason

6. Transactions using Paradox tables-Record Lock Failed - Losing faith in BDE

7. Browsing records Client/Server Application

8. Client/Server problem with Paradox-Tables in Delphi

9. ADO/OLE DB/MIDAS Multi-Tier/Client/Server applications in Delphi-5 for SQL-Server

10. Mixing different versions of Paradox tables