From: David Zoll <dzoll@nyscul.org>
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?
Date: Wed, 17 Jan 2001 13:17:57 -0500
Message-ID: <3A65E1D5.76ED9AEF@nyscul.org> (raw)
References: <200101162345.KAA04105@mustang.sdc.com.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: dzoll@nyscul.org, scldad@sdc.com.au
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?
In-Reply-To: <3A65E1D5.76ED9AEF@nyscul.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox