Board index » delphi » Paradox on peer network

Paradox on peer network

We developed a software that use paradox and it works on a peer network
(microsoft) with 3 stations. sometimes the records that are modified or
added are not saved and are lost, and sometimes they are saved.
Do you have some kind of solution to this problem?

--
Shimon Shed
CEO
ReportSoft International Ltd
Phone: 972-4-9929807
Fax: 972-4-9517058

 

Re:Paradox on peer network


Set LocalShare = true in bde configuration of
all workstations.

Make sure all workstations set for same net directory
on "server".   With application closed, search for and
delete all paradox and pdoxusr .net and .lck files.

Quote
Samyon Shed <sam...@isdn.net.il> wrote in message

news:378366E6.387775D9@isdn.net.il...
Quote
> We developed a software that use paradox and it works on a peer network
> (microsoft) with 3 stations. sometimes the records that are modified or
> added are not saved and are lost, and sometimes they are saved.
> Do you have some kind of solution to this problem?

> --
> Shimon Shed
> CEO
> ReportSoft International Ltd
> Phone: 972-4-9929807
> Fax: 972-4-9517058

Re:Paradox on peer network


Samyon

Maybe the users don't "Post" the modifications...
Maybe the users just turn off the machine and don't close the App before...
Maybe some form is being closed while some DataSet is in Edit state...
Maybe...something else.

Best Regards

Fernando Dias
Vidisco,S.A.

Re:Paradox on peer network


Hi,

In addition to the info in the borland TIs, look for  IPX/SPX compatible
protocol. This protocol doesn't work right, I would suggest changing to
NetBuei or TCP/IP.

Sean

Quote
Samyon Shed wrote:
> We developed a software that use paradox and it works on a peer network
> (microsoft) with 3 stations. sometimes the records that are modified or
> added are not saved and are lost, and sometimes they are saved.
> Do you have some kind of solution to this problem?

> --
> Shimon Shed
> CEO
> ReportSoft International Ltd
> Phone: 972-4-9929807
> Fax: 972-4-9517058

Re:Paradox on peer network


Make sure you have the BDE configured exactly as described in TI2989 at
www.borland.com/devsupport/bde/ti_list.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

Re:Paradox on peer network


We developed an application that use Paradox and runs on a three stations MS
Windows 95 network. Some Queries seems to be very slow, specially if the
Queries are Master/Detail. We use simple Queries linked together by
Datasources and some Params to change the results. In the server (the station
which has the tables and the application) the same queries are fast enough,
they take just a couple of seconds but in the other two take a minute and a
half. How can we speed up our Queries?

Re:Paradox on peer network


Quote
>We use simple Queries linked together by
>Datasources and some Params to change the results. In the server (the station
>which has the tables and the application) the same queries are fast enough,
>they take just a couple of seconds but in the other two take a minute and a
>half. How can we speed up our Queries?

if you want good performance Replace them with linked Ttables
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Re:Paradox on peer network


What network and protocol are you using?

Alain Quesnel
[remove the brackets on each side of my address to reply]

Ing. Carlos G. Czares Snchez <carlo...@cyberdude.com> wrote in message
news:37AB58C7.716A9900@cyberdude.com...

Quote
> We developed an application that use Paradox and runs on a three stations
MS
> Windows 95 network. Some Queries seems to be very slow, specially if the
> Queries are Master/Detail. We use simple Queries linked together by
> Datasources and some Params to change the results. In the server (the
station
> which has the tables and the application) the same queries are fast
enough,
> they take just a couple of seconds but in the other two take a minute and
a
> half. How can we speed up our Queries?

Re:Paradox on peer network


Quote
Alain Quesnel wrote:
> What network and protocol are you using?

I am using a peer to peer MSWindows 95 network and the main protocol is
NetBEUI, the computer use a Ethernet 10BaseT PCI Network Card, plugged to a
Hub.
Quote

> Alain Quesnel
> [remove the brackets on each side of my address to reply]

Re:Paradox on peer network


Quote
Brian Bushay TeamB wrote:
> >We use simple Queries linked together by
> >Datasources and some Params to change the results. In the server (the station
> >which has the tables and the application) the same queries are fast enough,
> >they take just a couple of seconds but in the other two take a minute and a
> >half. How can we speed up our Queries?

> if you want good performance Replace them with linked Ttables

Do TTables have better performance on a peer to peer network? Why?
Is Paradox a SQL compliant that work better with ttables than with Queries?
Quote

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Re:Paradox on peer network


Quote
>Do TTables have better performance on a peer to peer network? Why?
>Is Paradox a SQL compliant that work better with ttables than with Queries?

Access to data with Tables is faster than with Queries for Paradox.  Peer to
Peer networks are irrelevant to the speed difference between Tquery and Ttable.

Brian
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Re:Paradox on peer network


Have you tried TCP/IP?

--

Alain Quesnel
[remove the brackets on each side of my address to reply]

Ing. Carlos G.Czares Snchez <carlo...@intercable.net> wrote in message
news:37AC3017.FBC031D1@intercable.net...

Quote
> Alain Quesnel wrote:

> > What network and protocol are you using?

> I am using a peer to peer MSWindows 95 network and the main protocol is
> NetBEUI, the computer use a Ethernet 10BaseT PCI Network Card, plugged to
a
> Hub.

> > Alain Quesnel
> > [remove the brackets on each side of my address to reply]

Other Threads