From: Sean O'Dell <sean@...>
Date: 2004-07-29T09:49:42+09:00
Subject: Re: Stupid ODBC!

On Wednesday 28 July 2004 17:31, Lennon Day-Reynolds wrote:
> Server. However, if you build your own solution, you either have to
> modify the database schema, (which, in the case of the project I'm
> hoping to use Active Record on, is absolutely *not* an option) or keep
> the OID records somewhere other than the primary database, which
> complicates transaction handling considerably.

This won't help in your particular case, but in general I advocate putting all 
database activity into a middle layer and having applications call only the 
middle layer, never the database directly.  Managing unique IDs is something 
a middle layer can do very well, and it can just use a raw binary file (fast 
and safe) instead of the database.

	Sean O'Dell