the underlying reason is registry redirection.
32 bit apps on win64 get registry access to HKLM\Software redirected to
HKLM\Software\WOW6432Node
So the ODBC stuff which is all stored in the registry is in a different
location for 32 and 64 bit apps.
They didn't port their ODBC admin program to cover both stores, so you
need to run the one which matches.
Adrien
------ Original Message ------
From: "Barry Bell" <Barry_Bell@harte-hanks.com>
To: "Della-Croce, Gregory" <Greg_Della-Croce@wycliffe.org>;"Adrian
Klaver" <adrian.klaver@gmail.com>
Cc: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Sent: 6/06/2012 7:50:20 a.m.
Subject: Re: [ODBC] Why would Postgres not show in my data connections
(Win 7)
>640bit ODBC are visiable in Windows 7 control,
>32-bit ODBC drivers are only visible in " C:\Windows\SysWOW64\odbcad32.exe"
>
>You will find a separate list of 32-bit odbc drive list postgress.
>
>
>Thanks
>Barry Bell, IT Department
>Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell@harte-hanks.com
>
>
>-----Original Message-----
>From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Della-Croce, Gregory
>Sent: Tuesday, June 05, 2012 3:42 PM
>To: Adrian Klaver
>Cc: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] Why would Postgres not show in my data connections (Win 7)
>
>Thanks for responding! It is none of the lists: User, System, File DSN or Drivers. In fact the System DSN is blank.
And My Data Sources is also blank in File DSN. The only drivers that show are MS Access/dBASE, MS Access, MS ACCESS
Text,MS EXCEL, and SQL Server.
>Yes I am signed in as Admin when I did the psqlodbc install and I have opened the ODBC Data Source as Admin also.
>
>These are good questions. I wish they sparked an answer :)
>
>Greg Della-Croce
>
>-----Original Message-----
>From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
>Sent: Tuesday, June 05, 2012 3:32 PM
>To: Della-Croce, Gregory
>Cc: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] Why would Postgres not show in my data connections (Win 7)
>
>On 06/05/2012 10:11 AM, Della-Croce, Gregory wrote:
>
>>
>>As a novice to Postgres I have a small problem. I ran the install of
>>the ODBC Postgres drivers (psplodbc35w.dll), and I verified that the
>>file exists. However when I go to the Data Source manager in Windows 7
>>(Home
>>Premium) Postgres is not a database type in the list.
>>
>
>
>What list?
> User DSN
> System DSN
> File DSN
> or
> Drivers?
>
>Are you logged in as Administrator or not?
>
> Can anyone point
>
>>
>>me to what I may have done wrong? A link, article, anything!
>>
>>Greg Della-Croce
>>
>
>
>
>--
>Adrian Klaver
>adrian.klaver@gmail.com
>
>--
>Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-odbc
>
>
>
>--
>Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-odbc
>
>
