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

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".

HTH,
Stephen Davies

On Tue, 16 Jan 2001 15:13:39 -0500, "Adam Lang" said:
> I asked before, what do you mean it is password protected? I (just 5
> minutes ago to check) uninstalled the driver, downloaded it and reinstalled
> it and nowhere was I asked for a password.
>
> I'm downloading from here:
> ftp://ftp.postgresql.org/pub/odbc/index.html
>
> To try to register a dll, try typing: regsvr32 <path to dll>
> I'm not sure if this is good enough for the odbc driver manager though. I
> asked earlier for that tyoe of info today.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
> ----- Original Message -----
> From: "David Zoll" <dzoll(at)nyscul(dot)org>
> To: "PostgreSQL-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
> Sent: Tuesday, January 16, 2001 2:40 PM
> Subject: [INTERFACES] How do I install PostgreSQL ODBC Drivers for Windows
> from Source?
>
>
> >
> > I need to test ODBC access to PostgreSQL from Windows clients. Since
> > the latest binary distribution (postdrv.exe version 6.50.0) seems to be
> > password protected, and nobody seems to know the password, I downloaded
> > the source. Everything compiled fine in Visual C++ 6.0, and I now have
> > a psglodbc.dll file.
> >
> > What do I do with it? The PSQLODBC FAQ (at
> > http://404627944:81/post_down/odbc/psqlodbc_faq.html) says to copy the
> > file into c:\windows\system, but this is apparently insufficient, as the
> > driver doesn't show up in the drivers list under the ODBC Data Sources
> > section of Control Panel.
> >
> > Has anyone here installed this driver from source? How do you do it?
> > How do we go about getting these instructions into the documentation?
> >
> > Thank you very much in advance.
> >
> > Sincerely,
> > -David Zoll, Programmer
> > NYSCUL
> >
> > PS: If anyone has the password to actually run postdrv.exe, that would
> > be very much appreciated as well.

========================================================================
Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133