Arsen Khachatryan wrote:
>
> HI ALL I HAVE A PROGRAM WITH DELPHI WHERE THE USER INSERTS DATA INTO
> THE PARADOX DB (WITH BDE) NOW I HAVE A TWO COMPUTER AND WANT TO CONECT
> THIS DB TO TOHER COMPUTER AND THEN WITH THE SAME PROGRAM USERS CAN
> INSERT DATA INTO SAME DB .LIKE SERVER CLIENT.HOW CAN I DO OT PLEASE ?
>
> .
>
>  


Here is what worked for me when I  implemented this type of thing on Win98.
You must use Microsoft Network client for connecting to a shared folder 
on the network drive.
The database file will be on the shared folder, each user must have 
read/write access to it.
There is an excellent explanation of the details of what has to be done 
found at the delphi-db list. The link is
http://www.elists.org/pipermail/delphi-db/2000-May/001636.html

Here are some suggestions on what you have to do in the program.
The application you give to each user must do the following.

Use the BDE to connect to the paradox database on a network share, do 
not use the option of directly mapping the file in the Delphi IDE.  
Every user must connect to the network share containing the database 
file in the same way.

When your program starts up, it must clean up files left behind when 
other users were using the database.
When each user logs into the database, the program should attempt to 
delete the file PDOXUSRS.NET and the file PDOXUSRS.LCK files. You can 
choose where these go on the network, either with the application code 
or through the BDE, but they must be on the network in a folder that all 
the users of your application and access

You should use a Try ... Finally code block in the procedure that does 
this because if there is another user connected and using the table, 
there will be an error message for the user who tries to delete these 
files. These should be ignored and not displayed to the user, it is 
simply a result of using the file system to confirm that the file is in 
use. The purpose of this is to delete the files if they were left behind 
by another application that crashed or lost it's connection to the 
network. In this way your application will clean up after itself and 
avoid the disruption of having a .NET or .LCK file that is out of sync 
with the network session of the application.

You might look at the way the MastApp application in the Delphi Demos 
folder as a way of becoming familiar with the different configuration 
issues.

Regards,
Brian



------------------------ Yahoo! Groups Sponsor --------------------~--> 
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/i7folB/TM
--------------------------------------------------------------------~-> 

-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/delphi-en/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to