Re: Floorplan database

["Martyn Wendon" <martynwendon@xxxxxxxxxxx>]

Thanks again James,

Got it setup and working against mysql 5.0 which will make it really easy
to
get at the data for dynamic web pages.


Martyn

----- Original Message -----
From: James Traynor
To: xap_automation@xxxxxxx
Sent: Sunday, November 23, 2008 7:57 PM
Subject: Re: [xap_automation] Floorplan database


Hi,

Yep, certainly possible. Access DBs are never that great.  If you look in
the settings.txt file there are some instructions at the top about
configuring an ODBC database. I've used it against mysql but mssql should
be
fine too. Floorplan doesn't do anything particularly complicated with
databases so most should be fine.  It should create the tables once
configured, but you do need to create the database and give it a suitable
access account

hth

James

Martyn Wendon wrote:
Hi,

I've been having some issues with the Floorplan database where it seems to
randomly stop logging any data - a "compact and repair" in Access
and
restart of Floorplan fixes it, but obviously I lose data inbetween.

Is there a way to have Floorplan use an SQL database of some description? 
I
have mysql on the same machine so it would be useful if there's a way to
get
it working with that?  This would also make querying the data from web
pages
a lot easier too!



Thanks,

Martyn





------------------------------------