Tuesday, May 10, 2005 11:35 PM
Not much of a rant, nor a muse. We're all in Boston, attending Inmagic Dealer Days. Or more accurately, we're done attending dealer days and now are trying to relax even though the hotel bar closes way too early. Somehow I've not been able to sleep well, though that is normally NOT a problem for me. I could use a bucket of Visine.
Friday, May 06, 2005 1:38 PM
With ASP.NET set to impersonate a non-anonymous Windows account, I found the Inmagic ODBC driver flipped a henry when asked to perform a SELECT MAX statement. The error returned was "ERROR [S0000] [Inmagic, Inc.][DB/Text ODBC Driver]Unable to do ORDER BY".
It turns out that read/write permissions on the Documents and Settings\[machinename]\ASPNET\Local Settings\Temp folder are required (this is an XP machine I'm talking about). (Thank you Filemon.) I assume the ODBC driver requires some workspace in order to sort the records and pick the most maxest one. I don't know if this is the case with any ORDER BY clause or what. The ASPNET account has full control of that temp directory by default. Giving the Users group read/write access cured this otherwise intractable phenomenon (the Windows account in question was a member of the machine's Users group).
If you're wondering how to flip a henry, use your imagination.
Wednesday, May 04, 2005 3:35 PM
Long in the making, short in the viewing, fair-to-middling in the amount of edifying content; this short film sucks away 5 minutes of your life and never gives it back.
Synopsis: Andornotter Peter Tyrrell looks back with fond memories at crusty old Andornot and Inmagic websites regurgitated by the Internet Archive Wayback Machine
, then introduces the new Andornot website with the help of Benny Goodman and His Orchestra. 5 mins.