Received: from externals1.nyscul.org (www.nyscul.org [208.155.119.253])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0HINf044966
	for <pgsql-interfaces@postgresql.org>;
	Wed, 17 Jan 2001 13:23:41 -0500 (EST)
	(envelope-from dzoll@nyscul.org)
Received: by externals1.nyscul.org; id NAA19550;
	Wed, 17 Jan 2001 13:23:39 -0500 (EST)
Received: from unknown(10.1.0.15) by externals1.nyscul.org via smap (V4.2)
	id xma019541; Wed, 17 Jan 01 13:23:34 -0500
Received: from nyscul.org ([208.155.119.7]) by inets1.nyscul.org
	(Netscape Messaging Server 4.15) with ESMTP id G7BK9800.CD3;
	Wed, 17 Jan 2001 13:19:56 -0500
Message-ID: <3A65E1D5.76ED9AEF@nyscul.org>
Date: Wed, 17 Jan 2001 13:17:57 -0500
From: "David Zoll" <dzoll@nyscul.org>
X-Mailer: Mozilla 4.76 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Stephen Davies <scldad@sdc.com.au>
CC: PostgreSQL-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?
References: <200101162345.KAA04105@mustang.sdc.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200101/174
X-Sequence-Number: 790


Stephen Davies wrote:
> 
> There are two versions of the ODBC driver at ftp.postgresql.org: one is
> the full package including installer, the other is just the driver
> itself.
> 
> Once you have installed with installer once, you can upgrade by just
> copying new versions of the driver to windows\system.
> 
> If for some reason you cannot get the installer to work, you can do the
> install by hand with regedit.
> 
> Find the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI and add
>  the following:
> 
> REGEDIT4
> 
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
> "Setup"="C:\\WINDOWS\\SYSTEM\\PSQLODBC.DLL"
> "Driver"="C:\\WINDOWS\\SYSTEM\\PSQLODBC.DLL"
> "APILevel"="1"
> "ConnectFunctions"="YYN"
> "CommLog"="0"
> "Optimizer"="0"
> "DriverODBCVer"="02.00"
> "FileUsage"="0"
> "SQLLevel"="1"
> "UsageCount"=dword:00000001
> "Fetch"="100"
> "UniqueIndex"="1"
> "ReadOnly"="0"
> "UseCursors"="0"
> "UnknownSizes"="0"
> "TextAsLongVarchar"="0"
> "UnknownsAsLongVarchar"="0"
> "MaxVarcharSize"="254"
> "MaxLongVarcharSize"="4094"
> "ConnSettings"=""
> "UseDeclareFetch"="0"
> "BoolsAsChar"="0"
> "ExtraSysTablePrefixes"="dd_;"
> "Parse"="1"
> "Ksqo"="1"
> "CancelAsFreeStmt"="0"
> 
> (Note: check the above paths for your system)
> 
> Find the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
> and add an entry "PostgreSQL= Installed".

Thank you very much, that seems to have done it :-)

In my opionion, the above really should go in a README or INSTALL file
in the ODBC Driver source distribution.  Who do I talk to about getting
that included in the next release?

Sincerely,
-David Zoll, Programmer
NYSCUL