×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

BDE/Paradox: Multiuserdatabase access on Vista => application hangs

BDE/Paradox: Multiuserdatabase access on Vista => application hangs

BDE/Paradox: Multiuserdatabase access on Vista => application hangs

(OP)
Summary:  
A BDE-App (written in  D7) is used on several client computers, all clients  access the same database. The database files are on a VISTA-machine, clients are also VISTA
Problem: On first Client, the app starts normal, on the second it hangs on this line of code, where for the first time, a table is opened.

Anyone seen something like this, or any ideas? For hints, I would be very thankful.
Who knows, what exactly the bde doies on the PDOXUSRS.NET file?
I  have made a demonstration app. ( BDE must be installed separately) that I can send you

*******************************************************************
I know that I should get rid of the BDE, already working on it, but I need to bridge the time until this is done with a workaround.
The app must run on customer systems (XP, VISTA).  I'm NOT interested in suggestions like:
Get rid of BDE, Run your app in a virtual machine, use Novell or windows 2003 as file server.....
*******************************************************************
 
Details:
* The problem occured, when the database files were located on a VISTA Computer. I  tested Ultimate, business and 2008 Server. Access to files via explorer (New file, edit file...) works without problems,
* everythin works fine with data files on X or 2003 Server, or Novell
* PDOXUSRS.NET is located in a central folder on the Vista computer, path is given via UNC and is the same for all clients
* the well known oplocks-disable settings have been carried out on all computers, and checked via bdechecker
* on first client, app starts normal, on second one it hangs on that lines that tries to open a table (exclusive=False) for the first time. I've made a test app to show the problem
* on a XP Client I saw the error message: „Exception. Network initialization failed. Lock Time out. File: PDOXUSRS.NET. Directory: < path of  PDOXUSRS.NET File >"
* randomly, on Vista Clients I saw the error message: „Cannot lock network file. Operating system network error. File: PDOXUSRS.NET. File"
* I tried with and without UAC, no difference

I suppose: If BDE tries to get a special share access to the pdxousrs.net file, it fails if the file is on a Vista Computer
 

RE: BDE/Paradox: Multiuserdatabase access on Vista => application hangs

idapi32.cfg MUST be installed outside "program files" directory on Vista on ALL systems that use the BDE.

As far as the path to the netdir, in case you weren't aware - that path must match CHARACTER FOR CHARACTER on every machine that uses the BDE.  EXACT MATCH.  (I state this since many believe the paths must only resolve to the same location.)  That includes the system hosting the data, if it also uses the BDE.

And you are likely to get more specific help if you ask this in a forum for your programming language.  You might get help here, but this is 'paradox the application' rather than 'paradox the table format' or 'bde'.

Tony McGuire
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

RE: BDE/Paradox: Multiuserdatabase access on Vista => application hangs

(OP)
>>>>TonyMcGuire (Programmer) wrote:
idapi32.cfg MUST be installed outside "program files" directory on Vista on ALL systems that use the BDE.
<<<<<
I have tested this: I configured the cfg File to be in a new folder (on which all users have full read and write access), it made no difference.

>>>>TonyMcGuire (Programmer) wrote:
As far as the path to the netdir, in case you weren't aware - that path must match CHARACTER FOR CHARACTER on every machine that uses the BDE.  EXACT MATCH.  (I state this since many believe the paths must only resolve to the same location.)  That includes the system hosting the data, if it also uses the BDE.
<<<<<
The path is exactly the same, else it would say "Directory is controlled by other .NET file"

>>>>TonyMcGuire (Programmer) wrote:
And you are likely to get more specific help if you ask this in a forum for your programming language.  You might get help here, but this is 'paradox the application' rather than 'paradox the table format' or 'bde'.
<<<<<
Sorry I didn't find such a forum on this site

RE: BDE/Paradox: Multiuserdatabase access on Vista => application hangs

"Sorry I didn't find such a forum on this site "

Yes, they have one for various flavors of Delphi.  Under 'CodeGear' in Programming.

Tony McGuire
"It's not about having enough time; we have the rest of our lives.  It's about priorities."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close