sharing a database

[filipe26]

hi i have an application with a BDE Database.What procedures i have to consider to share these tables with another pc.How to share a BDE database between two pc's.Thanks.

 

[PascalKlaus]

With BDEAdmin on both PCs sets the section
Configuration/System/Init:

-LOCAL SHARE = true

in case of WinNT/2000/XP:
SHAREDMEMLOCATION = 0x5BDE
SHAREDMEMSIZE = 4096 (or 8192)

if you use Paradox:
Sets the section
Configuration/Vriver/Native/PARADOX

- Net Dir : A directory (the same on both PCs) on a network drive (not a local drive like c with access from both PCs.

In Delphi:
Set the property "Exclusive" in your TTables or TQueries e to false.

 

[filipe26]

these can be done automatically with the installshield configuration or Delphi or have to be made manually?

 

[PascalKlaus]

You have to do it manually with BDEADMIN.
This values are not default.

 

[filipe26]

yes but these values are stored in the instalation?

 

[PascalKlaus]

No, I think its stored in the idapi32.cfg.

 

[filipe26]

Now i have both pc's with the same shared BDE database,but i have a problem.It seems that the refresh button on the Tnavigator doesn't work.the tables are not refreshing when i append new records unless i close and open the table but when i do that obviously goes to the first record.Why refresh button doesn't work??

 

[filipe26]

Do i have to make that on both server and host or just in host?It seems that my tables dont refresh when i insert new records.