Skip site navigation (1) Skip section navigation (2)

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

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
Cc: "PostgreSQL-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?
Date: 2001-01-16 23:45:48
Message-ID: 200101162345.KAA04105@mustang.sdc.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
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



Responses

pgsql-interfaces by date

Next:From: Cedar CoxDate: 2001-01-17 08:35:04
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?
Previous:From: Jamie WalkerDate: 2001-01-16 21:30:46
Subject: Re: Re: MS Access memo datatypes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group