Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQLServer 2000

[Adam M. <ada...@ou...>]

I think Leeds Uni are THE Bodington.org SQLServer test site as nobody else
uses it! 

 

I guess in our defence, we simply haven't had time to cover all the bases,
poor show I agree but such are the pressures of work.

 

You're right though, we should either support SQLServer or remove it from
the list of supported databases!

 

adam

 

  _____  

From: bod...@li...
[mailto:bod...@li...] On Behalf Of M
Thomas
Sent: 14 December 2006 13:49
To: Bodington developers
Subject: [Bodington-developers] Bodington 2.8.0 incompatible with MS
SQLServer 2000

 

Hi All,

I'm concerned, as it seems that Bodington.org are no longer checking that
functionality works with all the supported database products. If I'm not
mistaken there have been no announcements regarding changes to the supported
database products since the addition of MySQL. So MS SQL server should still
be supported. 

Well I don't think it is. :o(

As I've had great fun working through all of the upgrade scripts altering
them to work with MS SQL server. In particular constraints that have been
shortened for other db products with no consideration for installations that
have the long versions. 
Then during testing I found that the event log method in facility has been
re-coded to use LIMIT and OFFSET within the query. As I'm sure most of you
are aware these are not supported by MS SQL server. Is there any other
product specific SQL out there that I should know about? 

I know it is not the end of the world, these things can be fixed! I'm just
irritated... Sorry for the rant! Just needed to get it out of my system, as
it reflects the bodington product badly.

For the 2.10 release I think the project needs to consider if it should
continue to support MS SQL server! 

Best Wishes

-- 
m.cha3l