Inmagic ODBC permissions when ASP.NET impersonates

by Peter Tyrrell 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.


Tags: Inmagic ODBC

Andornot Film Festival

by Administrator 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.


New Client website - Kitimat Museum

by Administrator Wednesday, March 16, 2005 2:29 PM
Through a grant from BC Digital Collections, the museum was able to purchase DB/TextWorks and Archives Online to catalog images covering the construction of the ALCAN smelter, facilities and town of Kitimat. Andornot assisted in development of the website and created HTML pages based on output from Archives Online. See

BC Cancer Agency launches revamped site with request option

by Administrator Monday, September 27, 2004 9:02 AM
The BCCA library catalogue now allows users to place requests to borrow items using Andornot Consulting's shopping/request cart technology. For more information on our requesting cart visit our WebPublisher Cart Add-on page.

Updated client website - Scarborough Hospital

by Administrator Thursday, May 27, 2004 8:48 AM
The Scarborough Hospital has just undergone a website make-over. As a result the Library section of the site followed suit and the library catalogue which is hosted on the Andornot server using WebPublisher PRO also had to be revamped. The catalogue can be viewed at: The features to note are the site integration with the search and display pages, the use of radio buttons for limiting the search and a couple of canned searches; see Electronic Journals and New Library Items on the left side bar.

Tags: News

Month List