From an old article we use with our clients. Download and try it today! If the database is accessed via N: Thursday, June 11, 4: With old apps closed all runs OK.

Uploader: Brarg
Date Added: 21 April 2008
File Size: 13.81 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 50494
Price: Free* [*Free Regsitration Required]

There are other strategies available, such as the ones implemented with the Andrew’s file-system which deal with the problem of distributed caches in a network, but for whatever reason Microsoft has decided to go their own route.

Use a file server not a workstationdisable Oplocks on the filer server, and optimize the BDE.

Databases – Borland Database Engine (BDE)

Whether or not the BDE files are stored on the network or on each workstation, the BDE runs on each workstation so these best practices paadox also workstation best practices. If your application uses the BDE to access Paradox tables, use the following best practices in order to maximize reliability and to increase speed where reliability does not suffer.

We need to access paradox tables from old Delphi aplications through BDE 5. From an old article we use parados our clients.

I used to recommend raising it to but enough CodeGear and dBASE users have suggested to me for various reasons that is a better setting. You want clean running computers If your application connects to a database or works with data, paradoox you really need to look at FireDAC.


Marked as answer by PetSe Tuesday, June 16, 6: I suppose that the connection string is ok, because if all BDE using applications are closed, it works fine. Drop TFDConnection on the form.

Comment 1 of 3. This site uses cookies for analytics, personalized content and ads. Do not ignore the “use a file server” standard already discussed, but if you do choose to go down that dangerous road, you must be sure that the computer that actually hosts the database does not use a local drive letter for paradix access nor for the NetDir. Loaded table is the Paradox 5.

Should you stay with Paradox tables?

Comment 3 of 3 I need use paradox. However, this begs the question, if I switch out my file server for a Server file server, are OpLocks still a problem? Posted 6 years ago. Thanks for your reply.

Do you recommend it? Sonmewhat older, but Citrix-centric. Our current recommendation is that if you’re having problems now with Paradox tables, disable OpLocks on the file server. Install now to protect your privacy. OpLocks are an additional protocol on top of the file-system locking protocol and was implemented for performance reasons.


Thursday, June 11, 2: No Freeze-Ups Standard If paradlx have a workstation that freezes up crashes every now and then, don’t ignore it, resolve the issue.

BDE – Paradox – ODBC driver for Paradox – Error (urgent) – delphi

OpLocks changed with Vista and Server And write local SQL against all these datasets! Every implementation of oplocks should be evaluated as a trade-off between perceived performance and ;aradox.

Message Board -New Activity. These guarantees inform the client that the file server will not allow another client to change the content of the file, or if some change is imminent, the client will be notified before the change is allowed to proceed.

Configuring opportunistic locking in Windows. I do know if you disable OpLocks on Vista, the offline files feature fails. In practice the idbc introduced by Microsoft are good enough when it comes to sharing files like Word documents or Excel spreadsheets in a networking parradox.