Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

paradox Database Sharing

i have 2 machines with my application, i ran both application. the other application loaded normally but the second one prompts an error

ERROR MESSAGE:

"Directory is controlled by other .NET file.
 Directory: C:\
 File: H:\DATABASE\PDOXUSRS.LCK."

how can i ran both application having a paradox database simultaneously?
anybody can share to me some answers?




       
0
ryan_sabarre
Asked:
ryan_sabarre
1 Solution
 
ryan_sabarreAuthor Commented:
anybody can help me?
0
 
balalaykaCommented:
did u try to change Local Share option as TRUE in BDE Administration/ Configuration tab/sytem/INIT (default driver should be paradox)
0
 
kretzschmarCommented:
before opening any table use

session.netfiledir := 'H:\DATABASE';

there are some another issues for using
paradox in a multiuser-enviroment

meikl ;-)
0
 
swift99Commented:
I really recommend using a real DBMS rather than Paradox tables.  Your reliability, even on a single user app, goes way up.  When sharing, your reliability and speed are improved by significant factors.

Interbase is cheap, its open-source variant (firebird) is free, MySQL is Free, and so on.

It's a bit more complex to set up, but it pays for itself the first time you don't have to rebuild your indexes as you often need to with Paradox.
0
 
PeterLarsenCommented:
You must use TSession - and be sure that the Net file is located on a drive visible to both computers.

Sometimes it's necessary to remove older Paradox.lck/Pdoxusr.lck if already exist. Normally the files is deleted automatically, but if the program crash they won't be deleted.

/PL
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now