how many client can access a shared table??

[Gert]

Hi all,

I would like to know how many client can access a shared table from VFP, i'been traying to send data from 16 computer at the same tame in a shared enviroment, but not all client can send the data.

thanksssss in advance

 

[DSummZZZ]

As many as you have licenses/connections for the server holding the table.


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[jimoo]

I am not aware of any client limitations as far as how many can access a table.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[alexisgacia]

It depends on the server. were using foxpro for dos and it can handle 150 clients.
Table can be corrupted if theres a client reset the computer.

 

[jimoo]

I should have been more specific, in VFP 3.0 and above I am unaware of any limitation.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[Gert]

I have VFP 5.0 and Windxp pro on the server

 

[ramani]

HI

To my knowledge, VFP does not limit.

Let us take it for practical limits, there is no limitation and for sure, 16 users is definetely not a limitation.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[craigsboyd]

When you say "...not all client can send the data." what exactly do you mean? Is it throwing an error on some workstations? Are certain changes just not getting saved? Does it lock up some of the workstations or bring down the server?

A few other questions come to mind...
Are all of the users trying to update the same record at the same time? Same Field? Do you have any locking strategies in place such as RLOCK() or FLOCK() in your application's code?

Slighthaze = NULL

[ul][li]FAQ184-2483
An excellent guide to getting a fast and accurate response to your questions in this forum.[/li][/ul]

 

[badukist]

For Win2000 and WinXP, the maximum connections to a shared resource (folder, printer, etc) is 10. You need a server OS to connect from more than 10 clients to a shared resource.
The same apply to 'inbound connections' to a specified port (as for SQL Server/MSDE).