Thread: PostgreSQL driver not visible in windows control panel

PostgreSQL driver not visible in windows control panel

From

"Fred Parkinson"

Date:

29 October 2012, 20:50:58

One of the employees here is having trouble connecting to a postgreSQL server, so while looking for the problem I opened Windows 7 control panel > administrative tools > Data Sources (ODBC) >Drivers (tab) and there are no postgreSQL drivers listed.

This employee can successfully connect to a different postgreSQL server on a different web server, so I was startled to see no drivers.

How is this possible? Is windows hiding the drivers for some reason? If so, how does one make Windows give up the information about the driver(s)?

Any ideas about what is happening greatly appreciated.

Fred

Re: PostgreSQL driver not visible in windows control panel

From

Nils Gösche

Date:

29 October 2012, 21:01:47

Hi Fred!

You probably installed the 32 bit version of the driver, right? If you open the ODBC dialog in the Control Panel, you see only the 64 bit drivers. To see the 32 bit drivers, run

C:\Windows\SysWOW64\odbcad32.exe

Regards,

Nils Gösche

"Don't ask for whom the <CTRL-G> tolls."

Von: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] Im Auftrag von Fred Parkinson
Gesendet: Montag, 29. Oktober 2012 18:51
An: pgsql-odbc@postgresql.org
Betreff: [ODBC] PostgreSQL driver not visible in windows control panel

This employee can successfully connect to a different postgreSQL server on a different web server, so I was startled to see no drivers.

How is this possible? Is windows hiding the drivers for some reason? If so, how does one make Windows give up the information about the driver(s)?

Any ideas about what is happening greatly appreciated.

Fred

Re: PostgreSQL driver not visible in windows control panel

From

"Fred Parkinson"

Date:

29 October 2012, 21:22:14

Thanks Nils.

I forgot that the support staff started installing 64 bit machines.

Once I ran odbcad32.exe all of the 32 bit drivers reappeared and I was able to move on to the next problem.

Thanks again!

Fred

>>> Nils Gösche<cartan@cartan.de> 10/29/2012 11:01 AM >>>

Hi Fred!

You probably installed the 32 bit version of the driver, right? If you open the ODBC dialog in the Control Panel, you see only the 64 bit drivers. To see the 32 bit drivers, run

C:\Windows\SysWOW64\odbcad32.exe

Regards,

Nils Gösche

"Don't ask for whom the <CTRL-G> tolls."

This employee can successfully connect to a different postgreSQL server on a different web server, so I was startled to see no drivers.

How is this possible? Is windows hiding the drivers for some reason? If so, how does one make Windows give up the information about the driver(s)?

Any ideas about what is happening greatly appreciated.

Fred

Re: PostgreSQL driver not visible in windows control panel

From

Lionel Elie Mamane

Date:

29 October 2012, 21:32:14

On Mon, Oct 29, 2012 at 10:50:49AM -0700, Fred Parkinson wrote:

> One of the employees here is having trouble connecting to a
> postgreSQL server, so while looking for the problem I opened Windows
> 7 control panel > administrative tools > Data Sources (ODBC)
> >Drivers (tab) and there are no postgreSQL drivers listed.

> This employee can successfully connect to a different postgreSQL
> server on a different web server, so I was startled to see no
> drivers.

If the OS is 64 bits, there may be two ODBC systems on the system: 64
bits and 32 bits. Possibly the employee is connecting through the 32
bit ODBC, but you are looking at the Data Sources manager of the 64
bit ODBC or vice-versa.

--
Lionel