Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4D0vFA45360 for ; Sat, 12 May 2001 20:57:15 -0400 (EDT) (envelope-from pgsql-docs-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4CNR8A21166 for ; Sat, 12 May 2001 19:27:08 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4CN7pW09262 for pgsql-docs@postgresql.org; Sat, 12 May 2001 19:07:51 -0400 (EDT) (envelope-from news) From: nt@atleastitisnotwindows.com X-Newsgroups: comp.databases.postgresql.docs Subject: Re: how to I connect ODBC to PostgreSQL in NT? Message-ID: References: X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 23 Date: Sat, 12 May 2001 23:07:49 GMT X-Complaints-To: news@bigpond.net.au Organization: BigPond Internet Services (http://www.bigpond.net.au) To: pgsql-docs@postgresql.org X-Archive-Number: 200105/62 X-Sequence-Number: 745 On Sat, 12 May 2001 22:18:52 GMT, nt@atleastitisnotwindows.com wrote: >I read ll the documentation I can find in the PostgreSQL 7.1.1 >download and searched the web a dozen different ways but have not >found the magic page that says how to install PostgreSQL ODBC in NT. >Is there a page I am missing? > >There are lots of pages saying >"I installed PostgreSQL ODBC and have this problem..." >They typically refer to an old PostgreSQL or an independent ODBC >driver. > >There is a psqlodbc.dll in one directory but not one line about what >to run to be able to use it in ODBC. MySQL installed their ODBC >driver automatically with the Win32 binary. PostgreSQL documentation >has a lot of hints that ODBC is available but not a line that says >"run this" or "copy that". > Found it. I had to download an old ODBC to get the magic page. Copy psqlodbc.dll to c:/winnt/system32 Find and run psqlodbc.reg (somewhere in distribution directories)