Vista will only open files exclusively for me

I have a multi-user system set up on a machine running Windows XP sp2.
SB2001 build is 526.  When I run the application from a Vista machine,
using the same runtime, via a mapped drive, I get one of the following
errors:
1. If the application is running already on an XP machine - 
"File is open for shared access", error number 132

2. If the application is opened first on the Vista machine and then on
the XP box - "File is open for exclusive access", error number 131.

The code is definitely written to open all files in shared mode and
works fine for several users all using Windows XP.

Has anyone encountered this problem?  Is there some sort of permission
I need to set on the Vista machine?

That is having no affect.  I had already tried the sb30.ini settings.
Here is the program I am using to test :

SUB main()
 superbase.localfilelocking = - 1
 OPEN FILE SHARE ,0"conxlook"
 SET RECORD 
 superbase.ProcessSelectionBar = - 1
 SELECT FIRST 
 WHILE - 1
    superbase.process()
 WEND 
 END SUB 
 
XP machines can run the program.  The Vista machine cannot if others
have opened the file first.  I am using the 10-user runtime with only
three machines in the test.

-Dan
 


On Tue, 02 Oct 2007 18:45:04 +0100, Neil Robinson <neil@simpol.com>
wrote:

>Dan Jinks wrote:
>> I have a multi-user system set up on a machine running Windows XP sp2.
>> SB2001 build is 526.  When I run the application from a Vista machine,
>> using the same runtime, via a mapped drive, I get one of the following
>> errors:
>> 1. If the application is running already on an XP machine - 
>> "File is open for shared access", error number 132
>> 
>> 2. If the application is opened first on the Vista machine and then on
>> the XP box - "File is open for exclusive access", error
number 131.
>> 
>> The code is definitely written to open all files in shared mode and
>> works fine for several users all using Windows XP.
>> 
>> Has anyone encountered this problem?  Is there some sort of permission
>> I need to set on the Vista machine?
>
>sblocal=None either in the INI file of the Vista machine, in the
>Environment variables of the Vista machine, or else LocalFileLocking=-1
>at the start of the program.
>
>Ciao, Neil

Dan Jinks wrote:
> I have a multi-user system set up on a machine running Windows XP sp2.
> SB2001 build is 526.  When I run the application from a Vista machine,
> using the same runtime, via a mapped drive, I get one of the following
> errors:
> 1. If the application is running already on an XP machine - 
> "File is open for shared access", error number 132
> 
> 2. If the application is opened first on the Vista machine and then on
> the XP box - "File is open for exclusive access", error number
131.
> 
> The code is definitely written to open all files in shared mode and
> works fine for several users all using Windows XP.
> 
> Has anyone encountered this problem?  Is there some sort of permission
> I need to set on the Vista machine?

sblocal=None either in the INI file of the Vista machine, in the
Environment variables of the Vista machine, or else LocalFileLocking=-1
at the start of the program.

Thanks Neil,
I'm waiting for the hotfix and will report back.

-Dan

On Wed, 03 Oct 2007 12:44:24 +0100, Neil Robinson <neil@simpol.com>
wrote:

>Dan Jinks wrote:
>> That is having no affect.  I had already tried the sb30.ini settings.
>> Here is the program I am using to test :
>> 
>> SUB main()
>>  superbase.localfilelocking = - 1
>>  OPEN FILE SHARE ,0"conxlook"
>>  SET RECORD 
>>  superbase.ProcessSelectionBar = - 1
>>  SELECT FIRST 
>>  WHILE - 1
>>     superbase.process()
>>  WEND 
>>  END SUB 
>>  
>> XP machines can run the program.  The Vista machine cannot if others
>> have opened the file first.  I am using the 10-user runtime with only
>> three machines in the test.
>
>Hhhmmmmm.
>
>This still points at the Vista machine. I stumbled over this hotfix for
>Vista that implies we aren't the only ones having problems:
>
>http://support.microsoft.com/kb/935366
>
>I found an interesting forum article about various problems in Vista:
>http://forums.microsoft.com/msdn/showpost.aspx?postid=1259708&siteid=1&a
mp;sb=0&d=1&at=7&ft=11&tf=0&pageid=1
>
>I have to say that I am having doubts about the viability of Vista as a
>serious platform to run Superbase applications on (or FoxPro, or Access,
>or any other non-client server system).
>
>Ciao, Neil

Dan Jinks wrote:
> That is having no affect.  I had already tried the sb30.ini settings.
> Here is the program I am using to test :
> 
> SUB main()
>  superbase.localfilelocking = - 1
>  OPEN FILE SHARE ,0"conxlook"
>  SET RECORD 
>  superbase.ProcessSelectionBar = - 1
>  SELECT FIRST 
>  WHILE - 1
>     superbase.process()
>  WEND 
>  END SUB 
>  
> XP machines can run the program.  The Vista machine cannot if others
> have opened the file first.  I am using the 10-user runtime with only
> three machines in the test.

Hhhmmmmm.

This still points at the Vista machine. I stumbled over this hotfix for
Vista that implies we aren't the only ones having problems:

http://support.microsoft.com/kb/935366

I found an interesting forum article about various problems in Vista:
http://forums.microsoft.com/msdn/showpost.aspx?postid=1259708&siteid=1&s
b=0&d=1&at=7&ft=11&tf=0&pageid=1

I have to say that I am having doubts about the viability of Vista as a
serious platform to run Superbase applications on (or FoxPro, or Access,
or any other non-client server system).