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

[schoellm]

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

 

[TonyMcGuire]

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.

 

[schoellm]

>>>>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

 

[TonyMcGuire]

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.

 

[schoellm]

Problem's solved, I was given an advice here:

http://www.delphipages.com/threads/thread.cfm?ID=195262&G=195217

It's a Vista Bug