Alaska Software Inc. - FLock(), DbRLock() in 2 PC with Vista

	Author	Topic: FLock(), DbRLock() in 2 PC with Vista
	Paulo Pinheiro	FLock(), DbRLock() in 2 PC with Vista on Tue, 25 Sep 2007 18:31:39 +0100 Hello All I have a problem with 2 PC running Vista: - one is the database and application server. Ex: C:\APP - the other is the client. The client has a network drive to server. Ex: X:\APP Both pc runs the application and: - a DbRLock() is made in the CLIENT - then when a DbRLock() is made in SERVER it returns FALSE immediatly allowing the application to control the situation. BUT if: - the DbRLock() is made first in SERVER - when the CLIENT tries to do the DbRLock(), it DOESN'T return FALSE immediatly ==> it WAITS until the record is available Notes: 1 - The applications are trying to access the same record of the same table no doubt about that. 2 - If one of the PC is WinXP this doesnt happen. It works fine. 3 - I also tried to run the application as Administrator and with Compatibility WinXp Service Pack 2 without success. 4 - This happens with both Windows Vista Business and Ultimate I hope the problem was well presented and easily understandable. If not i am sorry. Any help? Best Regards, Paulo Pinheiro
	Paulo Pinheiro	Re: FLock(), DbRLock() in 2 PC with Vista on Tue, 25 Sep 2007 18:33:24 +0100 Sorry for this post. Wrong group.

Author

Topic: FLock(), DbRLock() in 2 PC with Vista

FLock(), DbRLock() in 2 PC with Vista
on Tue, 25 Sep 2007 18:31:39 +0100

Hello All

I have a problem with 2 PC running Vista:
  - one is the database and application server. Ex: C:\APP
  - the other is the client. The client has a network drive to server. Ex: 
X:\APP

Both pc runs the application and:
  - a DbRLock() is made in the CLIENT
  - then when a DbRLock() is made in SERVER it returns FALSE immediatly 
allowing the application to control the situation.

BUT if:
  - the DbRLock() is made first in SERVER
  - when the CLIENT tries to do the DbRLock(), it DOESN'T return FALSE 
immediatly ==> it WAITS until the record is available

Notes:
  1 - The applications are trying to access the same record of the same 
table no doubt about that.
  2 - If one of the PC is WinXP this doesnt happen. It works fine.
  3 - I also tried to run the application as Administrator and with 
Compatibility WinXp Service Pack 2 without success.
  4 - This happens with both Windows Vista Business and Ultimate

I hope the problem was well presented and easily understandable. If not i am 
sorry.
Any help?

Best Regards,
Paulo Pinheiro

Paulo Pinheiro

Re: FLock(), DbRLock() in 2 PC with Vista
on Tue, 25 Sep 2007 18:33:24 +0100

Sorry for this post. Wrong group.