Jooooto


the subjected message: Connection:xFoxComm is busy.

when running the Foxpro Application in SQL Server with WinXP workstation.

pls help





Re: Error Msg: Connection:xFoxComm is busy

dni


What operating system is on the server You may check to have no more than 6 computers connected to yours, depending on xp flavor.





Re: Error Msg: Connection:xFoxComm is busy

Jooooto

Thanks dni!

Here is the configuration:

Server side: Windows 2000 server SP4, MS SQL Server 2000

Workstation : Windows XP SP2

Application: VFP 8.0

The error is happened arbitary but usually happened when a lot of tables are opened at the same time. Hope it can has enough information. Thanks in advance.







Re: Error Msg: Connection:xFoxComm is busy

dni

As I know xp support (if is proffessional) 10 concurent connections and I think w2000, 49 or more.
First I will check number of concurent connections to the server, permissions for work station to server,
connection string in vfp. It is important thet when users don't work to close tables and what is xFOXCOMM





Re: Error Msg: Connection:xFoxComm is busy

Jooooto

Hi dni, I have changed the workstation to Win2000 and it works.

However, how to solve the problem if we need to change the OS back to XP do you mean we need to upgrade the OS of the server






Re: Error Msg: Connection:xFoxComm is busy

dni

You may need to limit, some how, network access to xp computer to 10. (You may move some shared files to server...). I think you may keep server os but try to uptdate to the last sp.




Re: Error Msg: Connection:xFoxComm is busy

Jooooto

Thanks for your help!!