We are looking to deploy CCM's Facility timetable / scheduler next September which uses M$ SQL 7 as standard. Does any one out there use this software with a Linux DB, DB2 and Oracle are the most obvious. My manager is not keen on MYSQL, but if some one is using it for this successfully it might change his mind!
Before doing so, ask them "will it run on any database?" because that's what their literature says, then ask them "why won't it run on PostgreSQL" (ditto MySQL): they told me that's because no-one wants it ("we've only ever had one request for this"). For political reasons I've had to install it here. It's our only Windows server. We've managed today to make a connection from our Apache/PHP to the CMIS database, which should prove very useful. We can now write our own lookup scripts, which look as if they'll be a lot faster and certainly more platform-independent than theirs. But hard work ... As they said after we'd bought it "this is only a front end. You need to go on some training courses to learn about managing NT and about SQL Server". But if it wasn't only a front end, we wouldn't be able to get at the data. -- Christopher Dawkins, Felsted School, Dunmow, Essex CM6 3JG 01371-822698/821076 or 07798 636725 cchd@felsted.essex.sch.uk