dbTalk Databases Forums  

Error opening Foxpro Table using UNC on XP Operating System

comp.databases.xbase.fox comp.databases.xbase.fox


Discuss Error opening Foxpro Table using UNC on XP Operating System in the comp.databases.xbase.fox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ernie
 
Posts: n/a

Default Error opening Foxpro Table using UNC on XP Operating System - 11-05-2004 , 06:14 AM






Hello,

We are experiencing an error in our programs running on XP operating
Systems. We are using VFP 7.0 and get a "File is in use" error when
using UNC to open a table. The error does not make sense since the
table in question is already opened by many users at the time of the
error. It only occurs on certain computers and only on the XP boxes.
Our 98 cpu's are fine. Changing how the file is opened fixes the
problem. But we have this style of codeing in many of our
applications. Has anyone else ran into this issue?

Ex:

Use \\servername\volume\folder\filename.dbf in 0 shared - Causes error

Use \folder\filename.dbf in 0 shared - works

Any information would be appreciated.

Thank You,
Ernie

Reply With Quote
  #2  
Old   
Josh Assing
 
Posts: n/a

Default Re: Error opening Foxpro Table using UNC on XP Operating System - 11-05-2004 , 07:49 AM






Something is wrong.. I just tested this using 7 -- had no problems...
perhaps produce some small code snippet (including table generation) to
illustrate the problem you're experiencing?

On 5 Nov 2004 04:14:32 -0800, erndogwatson (AT) yahoo (DOT) com (Ernie) wrote:

Quote:
Hello,

We are experiencing an error in our programs running on XP operating
Systems. We are using VFP 7.0 and get a "File is in use" error when
using UNC to open a table. The error does not make sense since the
table in question is already opened by many users at the time of the
error. It only occurs on certain computers and only on the XP boxes.
Our 98 cpu's are fine. Changing how the file is opened fixes the
problem. But we have this style of codeing in many of our
applications. Has anyone else ran into this issue?

Ex:

Use \\servername\volume\folder\filename.dbf in 0 shared - Causes error

Use \folder\filename.dbf in 0 shared - works

Any information would be appreciated.

Thank You,
Ernie

---
Remove x's to send.


Reply With Quote
  #3  
Old   
Gene Wirchenko
 
Posts: n/a

Default Re: Error opening Foxpro Table using UNC on XP Operating System - 11-05-2004 , 11:27 AM



erndogwatson (AT) yahoo (DOT) com (Ernie) wrote:

Quote:
We are experiencing an error in our programs running on XP operating
Systems. We are using VFP 7.0 and get a "File is in use" error when
using UNC to open a table. The error does not make sense since the
table in question is already opened by many users at the time of the
error. It only occurs on certain computers and only on the XP boxes.
Our 98 cpu's are fine. Changing how the file is opened fixes the
problem. But we have this style of codeing in many of our
applications. Has anyone else ran into this issue?
Are you quite sure that many users have the table open? (If not,
it could be that one other has the table open exclusive.)

Quote:
Ex:

Use \\servername\volume\folder\filename.dbf in 0 shared - Causes error

Use \folder\filename.dbf in 0 shared - works
These names are not necessarily equivalent. Maybe, your network
mappings are wrong.

Quote:
Any information would be appreciated.
Post the outcome, please.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


Reply With Quote
  #4  
Old   
Bill Browne
 
Posts: n/a

Default Re: Error opening Foxpro Table using UNC on XP Operating System - 11-12-2004 , 06:02 PM



Gene (and others):

I don't think it's an 'exclusive' problem. When I try opening a file
already opened as exclusive, I get 'Access denied'. 'File is in use' comes
up when the app already has that table open and you try to open without the
'again' clause.

I'd say the app already has the table open, and the different file name is
either pointing to a different file, or fooling fox into thinking it's
opening a different file. I would be curious to see a 'display status'
after the file is opened.

--
Bill Browne
www.edgefinderstudios.com


"Gene Wirchenko" <genew (AT) mail (DOT) ocis.net> wrote

Quote:
erndogwatson (AT) yahoo (DOT) com (Ernie) wrote:

We are experiencing an error in our programs running on XP operating
Systems. We are using VFP 7.0 and get a "File is in use" error when
using UNC to open a table. The error does not make sense since the
table in question is already opened by many users at the time of the
error. It only occurs on certain computers and only on the XP boxes.
Our 98 cpu's are fine. Changing how the file is opened fixes the
problem. But we have this style of codeing in many of our
applications. Has anyone else ran into this issue?

Are you quite sure that many users have the table open? (If not,
it could be that one other has the table open exclusive.)

Ex:

Use \\servername\volume\folder\filename.dbf in 0 shared - Causes error

Use \folder\filename.dbf in 0 shared - works

These names are not necessarily equivalent. Maybe, your network
mappings are wrong.

Any information would be appreciated.

Post the outcome, please.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.