Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?

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