Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.1/8.9.1) with ESMTP id RAA13055 for ; Fri, 20 Nov 1998 17:01:44 -0500 (EST) (envelope-from daveh@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id QAA14733 for pgsql-interfaces@postgreSQL.org; Fri, 20 Nov 1998 16:33:41 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA11072; Fri, 20 Nov 1998 16:21:04 -0500 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA21180; Fri, 20 Nov 1998 16:20:03 -0500 Message-Id: <3655DDE7.2679981F@insightdist.com> Date: Fri, 20 Nov 1998 16:23:51 -0500 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en Mime-Version: 1.0 Cc: Diego Bariquet , pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Re: OBBC for MS Access97 References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The Hermit Hacker wrote: > On Fri, 20 Nov 1998, Diego Bariquet wrote: > > > Dear Mr. Webmaster, > > > > I have change my Microsoft NT server to a Linux running on > > Slackware 3.5 last week and will set up another server on Red Hat 5.1 > > early next month. > > > I have a front end application written on Microsoft Access 97 and > > plan to used PostgreSQL as my back end database server. I am wondering > > if you have the ODBC so that I could transfer my back end to > > PostgreSQL. > > I'm not sure if I'm fully understanding your question, but there is an > ODBC driver that does come with the standard distribution of PostgreSQL, > in the src/interfaces/odbc director We do lot things using MS Access and PostgreSQL in the backend. Mostly queries and such. We have also done some forms prototyping with relative ease. I cannot guarantee that your conversion will be trouble free. You may have to get your hands dirty. I strongly recommend that you get the latest version of the driver from our web site at: http://www.insightdist.com/psqlodbc You will also want to get the latest version (6.4) of the server.