Re: 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.

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.

On Tue, 16 Jan 2001, David Zoll wrote:
>
> 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.

I know I've said this before, but I still suspect a virus is at work.
David, where did you download postdrv.exe? If the same file is running
correctly on someone else's system and asking for a password on yours,
something strange is going on, to say the least. I've seen this before
with a different packager/installer, as well as self extracting winzip
archives being corrupted. If you have anti-virus software, make sure you
update to the latest virus defs. If not, at least go to www.pspl.com and
get the CIH virus cleaner (and run it from dos mode).

-Cedar

Adam,
there are two kinds of dll's.
* A classical dll, made with c or c++, has just to be copied into
windows\system
* An ActiveX dll has to be registered with regsvr32.
I suspect that odbc driver dll is a classical dll, so it only has to
be copied into windows\system
Hope this helps
Andrea

Adam Lang wrote:
>
> 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.

Cedar Cox wrote:
>
> On Tue, 16 Jan 2001, David Zoll wrote:
> >
> > 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 havea psglodbc.dll file.
>
> I know I've said this before, but I still suspect a virus is at
> work. David, where did you download postdrv.exe?

Directly from ftp://ftp.postgresql.org/pub/odbc/latest/, three separate
times.

> If the same file is running correctly on someone else's system
> and asking for a password on yours, something strange is going on,
> to say the least.

So far I've only heard one person say the installer actually works, and
found at least two other messages in mailing list archives asking for
the password. Last time I asked here, your virus suggestion was the
only response.

> I've seen this before with a different packager/installer, as well
> as self extracting winzip archives being corrupted. If you have
> anti-virus software, make sure you update to the latest virus defs.
> If not, at least go to www.pspl.com and get the CIH virus cleaner
> (and run it from dos mode).

I've tried the CIH virus cleaner, and I've checked with Innoculan with
the latest virus updates. As far as I can tell my machine is clean of
any and all known viruses.

That doesn't mean that I don't have a corrupted or misversioned DLL file
somewhere. If the installer program truly does work, than a bad DLL on
my machine is most likely the problem.

Thank you very much for your help.

Sincerely,
-David Zoll, Programmer
NYSCUL

Adam Lang wrote:
>
> I asked before, what do you mean it is password protected?

If you had asked before, I must have missed it. I apologize.

I mean the following:
1) I download ftp://ftp.postgresql.org/pub/odbc/latest/postdrv.exe
2) I run it
3) A popup window appears with the title "InstallShield
Self-extracting EXE", which asks me "This will install PostgreSQL
ODBC Driver v6.50.0000. Do you wish to continue?"
4) I click on "OK"
5) Another popup window appears with the title "InstallShield
Self-extracting Exe" (yes the case is different on "Exe"), which
says "Please enter the password required to extract the attached
files." It has a text field, presumably for entering in a
password.
6) I enter something in (or even nothing).
7) My machine dings, and another popup window appears with the title
"InstallShield Self-extracting EXE" (back to the original all-caps
EXE), informing me that "You have entered an incorrect password."
8) I hit the "OK" button.
9) The program exits, having extracted and installed nothing.

> I (just 5 minutes ago to check) uninstalled the driver,
> downloaded it and reinstalled it and nowhere was I asked for a
> password.

Then there must be something different between our machines that is
causing a problem on mine. I've found archives of two other requests
for such a password, so while the problem may be rare, it is not unique
to my machine.

> I'm downloading from here:
> ftp://ftp.postgresql.org/pub/odbc/index.html

As am I.

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

Stephen Davies posted excellent instructions that registered the driver
with the ODBC system, so that's no longer a problem for me, but I think
it might still be a good thing to figure out what is breaking in the
installer program so others don't have this problem in the future. Does
anyone know where to get the files used to generate the installer?

Sincerely,
-David Zoll, Programmer
NYSCUL

I honestly do not know what to say about the password problem. I've had
installed the drivers several times on different PCs and not a problem has
arisen. Never installed it on NT though.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "David Zoll" <dzoll(at)nyscul(dot)org>
To: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
Cc: "PostgreSQL-interfaces" <pgsql-interfaces(at)postgresql(dot)org>

I just pulled a fresh copy from ftp://ftp.postgresql.org/pub/odbc/latest/
It's 1154726 bytes in size. I started an install on NT 4.0

On Wed, Jan 17, 2001 at 01:44:22PM -0500, David Zoll wrote:
>
>
> Adam Lang wrote:
> >
> > I asked before, what do you mean it is password protected?
>
> If you had asked before, I must have missed it. I apologize.
>
> I mean the following:
> 1) I download ftp://ftp.postgresql.org/pub/odbc/latest/postdrv.exe
> 2) I run it
> 3) A popup window appears with the title "InstallShield
> Self-extracting EXE", which asks me "This will install PostgreSQL
> ODBC Driver v6.50.0000. Do you wish to continue?"
> 4) I click on "OK"

Yep, same to here.

> 5) Another popup window appears with the title "InstallShield
> Self-extracting Exe" (yes the case is different on "Exe"), which
> says "Please enter the password required to extract the attached
> files." It has a text field, presumably for entering in a
> password.

Nope. don't get this at all. Are you running as an Adminstrator? Perhaps
NT is complaining about where the zip extractor is trying to write its
files, and the extractor then tries the password route.

>
> > I'm downloading from here:
> > ftp://ftp.postgresql.org/pub/odbc/index.html
>
> As am I.

Ditto

On Wed, Jan 17, 2001 at 02:04:17PM -0500, Adam Lang wrote:
> I honestly do not know what to say about the password problem. I've had
> installed the drivers several times on different PCs and not a problem has
> arisen. Never installed it on NT though.
>

I'm installing on NT 4.0.

Ross

On Wed, Jan 17, 2001 at 02:42:03PM -0600, Ross J. Reedstrom wrote:
> I just pulled a fresh copy from ftp://ftp.postgresql.org/pub/odbc/latest/
> It's 1154726 bytes in size. I started an install on NT 4.0
>
> I'm installing on NT 4.0.

And it completed successfully (sorry I didn't make that clear)

Ross

On Wed, 17 Jan 2001, David Zoll wrote:

> So far I've only heard one person say the installer actually works,

I just downloaded and went through the steps you described for
installing postdrv.exe from ftp.postgresql.org, and it worked fine, so
if there's any reluctance to believe that it works because only one
person said so, now you have two. :->}

--
Bob Kline
mailto:bkline(at)rksystems(dot)com
http://www.rksystems.com

> So far I've only heard one person say the installer actually works,
> and found at least two other messages in mailing list archives asking
> for the password. Last time I asked here, your virus suggestion was
> the only response.

To add to the information base, I have installed the driver in at least
two diffferent versions on about three Win-98 machines, with succesful
installations.

I _have_ seen the password problem (on Win-98), but I can't remember
what I did wrong. But in the end there was nothing wrong with the
zip-file, it was something else.

///Jens Carlberg

On Wed, 17 Jan 2001, David Zoll wrote:
>
> That doesn't mean that I don't have a corrupted or misversioned DLL file
> somewhere. If the installer program truly does work, than a bad DLL on
> my machine is most likely the problem.

... Not unlikely knowing windows.. Perhaps someone could contact the
Install Shield people? Surely they would know something about this.