checking on database if user is online or no.

rlHitech · Joined: 28 Oct 2009 Posts: 46

Hello
We are developing a Windows form application that will monitor our hotspots and i would like to know if it is possible on the database.dbf to checkit out if we have users on line using the odbc.
Regards,

Renato

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Yes, you can check the field "reserved1" in table fsusr. Refer to chapter 5 of firstspot_guide.pdf for details.
_________________
~ Patronsoft Limited ~

rlHitech · Joined: 28 Oct 2009 Posts: 46

One more question.
We are running the code on C# and we will use ODBC for acessing it.
I have read on the manual that direct consultations to the dbf file may crash the system.

Given that in the future we also intend that this program create pins, what apropriate measure would you recommend us ?

Regards,
Renato

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Please check out http://patronsoft.com/forum/viewtopic.php?t=1514 for a guideline.
_________________
~ Patronsoft Limited ~

ryanslimmon · Joined: 24 Jun 2009 Posts: 23 Location: Calgary, AB

If you stop using the default database files and move your database to a SQL Database (i.e. SQL Server Express, MySQL, etc), then you can access the data directly while the server is online. Not that I am recommending that you change the data directly, its just accessible to you.

(I've had many bad experiences with dBase III/IV and access databases that I will stay clear of them if i can.)

Currently we run firstspot against SQL Server 2008 Express, and it works well. The Firstspot guide has the SQL Commands to build your initial database.