Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA29478 for ; Fri, 24 Jul 1998 12:22:28 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA08413 for pgsql-general@postgreSQL.org; Fri, 24 Jul 1998 12:05:36 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA29942; Fri, 24 Jul 1998 12:00:22 -0400 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA61952; Fri, 24 Jul 1998 12:00:22 -0400 Message-Id: <35B8AF9F.D9A5B227@insightdist.com> Date: Fri, 24 Jul 1998 12:00:31 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Bruce Tong Cc: "pgsql-interfaces@postgreSQL.org" , PostgreSQL General Subject: Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!! References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bruce Tong wrote: > > > The working version of \windows\system\MSJET35.DLL is 3.51.0623.4 > > The broken version I tested was 3.50.3602.4 > > I'm not sure at what release they fixed this problem. > > > > I will dig around on MS web site. > > > > Does anyone know if its OK to redistribute the MS JET DB Engine DLL, > > like with our ODBC driver for example??? (That thing is big too, > > 1MB!!!) > > > > For that matter, is there a simple way to get it from Microsoft? > Yes, I found the updated jet database engine on Microsoft site. http://support.microsoft.com/download/support/mslfiles/Jet35upd.exe > I don't know the answers to these questions, but if you're just doing this > to save me time there's no reason to put yourself out as that's something > I should do for myself. If you're planning on distributing the DLLs along > with the driver, that sounds like a great idea, assuming they'll let you. > Well, this Access order by problem has bothered us and many others that use the odbc front end with postgres for quite some time. Its a great relief to finally have a clear understanding of the problem! I think we will probably just include a link to the above site off of our site and mention this problem. > I take it I don't have to gather the log information you requested? > No, thanks anyway. Byron