Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

PostgreSQL driver not visible in windows control panel

4 views
Skip to first unread message

Fred Parkinson

unread,
Oct 29, 2012, 1:50:49 PM10/29/12
to
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

Nils Gösche

unread,
Oct 29, 2012, 2:01:42 PM10/29/12
to

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

Fred Parkinson

unread,
Oct 29, 2012, 2:22:02 PM10/29/12
to
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<car...@cartan.de> 10/29/2012 11:01 AM >>>

Lionel Elie Mamane

unread,
Oct 29, 2012, 2:32:07 PM10/29/12
to
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


--
Sent via pgsql-odbc mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

0 new messages