Обсуждение: Why would Postgres not show in my data connections (Win 7)

On 05/06/2012 18:11, 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.   Can anyone
> point me to what I may have done wrong?  A link, article, anything!

The only thing I can think of is that you're running a 64-bit OS and
you've installed the 32-bit ODBC driver; if that's the case, then you
need to use the 32-bit driver manager to see the driver, set up DSNs
etc. It should be here:

   C:\Windows\SysWOW64\odbcad32.exe

Hope this helps,

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

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

Thanks for responding!  It is none of the lists: User, System, File DSN or Drivers.   In fact the System DSN is blank.
AndMy 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

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

On 06/05/2012 12:41 PM, Della-Croce, Gregory wrote:
> 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
ACCESSText, 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 :)

In that case Rays answer is the one you should pursue. For more info see:


http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Where_is_the_PostgreSQL_ODBC_driver.3F_I.27m_running_32-bit_PostgreSQL_on_64-bit_Windows
>
> Greg Della-Croce



--
Adrian Klaver
adrian.klaver@gmail.com

Thanks all that got me to the right place to set up the connection!   Great advice.  I thought I had done it earlier
butnow it gives me the system DSN values I need to set up the connection for my stuff. 

Greg Della-Croce

On 06/05/2012 12:41 PM, Della-Croce, Gregory wrote:
> 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
ACCESSText, 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 :)

In that case Rays answer is the one you should pursue. For more info see:


http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Where_is_the_PostgreSQL_ODBC_driver.3F_I.27m_running_32-bit_PostgreSQL_on_64-bit_Windows
>
> Greg Della-Croce



--
Adrian Klaver
adrian.klaver@gmail.com

Suggest your use a DSN-less connection if possible, Connection string below works for me:
"Driver={PostgreSQL
ANSI};Server=servername;Port=5432;Database=dbname;Uid=username;Pwd=password;BI=2;TextAsLongVarchar=1;UnknownSizes=2;"

This eliminates a lot of setup issues on a the end user (or end server) machine

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 4:36 PM
To: Adrian Klaver
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Why would Postgres not show in my data connections (Win 7)

Thanks all that got me to the right place to set up the connection!   Great advice.  I thought I had done it earlier
butnow it gives me the system DSN values I need to set up the connection for my stuff. 

Greg Della-Croce

On 06/05/2012 12:41 PM, Della-Croce, Gregory wrote:
> 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
ACCESSText, 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 :)

In that case Rays answer is the one you should pursue. For more info see:


http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#Where_is_the_PostgreSQL_ODBC_driver.3F_I.27m_running_32-bit_PostgreSQL_on_64-bit_Windows
>
> 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

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.   Can anyone point me to what I may have done wrong?  A link, article, anything!

 

Greg Della-Croce

Applications Administrator

 

Greg_Della-Croce@Wycliffe.org

SKYPE: GDellaCroce55

Cell: 407-408-2572

                                                                   THINK ON THIS:

"All that is valuable in human society depends upon the opportunity for development accorded the individual" ~ Albert Einstein

“All this is valuable in Christ’s Kingdom depens upon the opportunity for development accorded the individual by the Holy Spirit to Glorify the Father”  ~ Greg Della-Croce

 

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

 

If you're on a 64 bit OS, and you installed the 32 bit driver, it will only show up under the 32 bit ODBC manager, which is in windows\SysWOW64\odbcad32.exe

 

Regards

 

Adrien

----

Adrien de Croy - WinGate Proxy Server - http://www.wingate.com/
WinGate 7 is released! - http://www.wingate.com/getlatest/

------ Original Message ------
From: "Della-Croce, Gregory" <Greg_Della-Croce@wycliffe.org>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Sent: 6/06/2012 5:11:18 a.m.
Subject: [ODBC] Why would Postgres not show in my data connections (Win 7)

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.   Can anyone point me to what I may have done wrong?  A link, article, anything!

 

Greg Della-Croce

Applications Administrator

 

Greg_Della-Croce@Wycliffe.org

SKYPE: GDellaCroce55

Cell: 407-408-2572

                                                                   THINK ON THIS:

"All that is valuable in human society depends upon the opportunity for development accorded the individual" ~ Albert Einstein

“All this is valuable in Christ’s Kingdom depens upon the opportunity for development accorded the individual by the Holy Spirit to Glorify the Father”  ~ Greg Della-Croce