Skip site navigation (1) Skip section navigation (2)

cant get odbc driver to work properly on windows 64 bit

From: Mike Broers <mbroers(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: cant get odbc driver to work properly on windows 64 bit
Date: 2009-11-20 17:54:21
Message-ID: c7ca62850911200954t546bd436leba8d10b982ca450@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I have gone through the archives and seen people who used the 64bit build
and people who build the dsns in the 32 bit version of the odbc manager
found under syswow64 but neither of those approaches are what I am looking
for.

1.  i have an existing environment that is windows 2008 64 bit which has the
postgres unicode driver installed and working, when i go to odbc manager i
see postgres unicode in the drivers list, and the processes which connect to
the database using this driver work fine.  this is psqlodbc35w.dll,
8.03.02.00.

2.  i have tried to use the msi to install 8.03.02.00 on a second fresh
windows 2008 64 bit server and i get the same problem everyone else has, the
postgres unicode driver doesnt show up in the drivers list.  like i said i
can get at it using the odbcad32 under syswow64 but after setting that up it
still doesnt work properly (complains about a driver/app mismatch, still
doesnt show up in 64 bit drivers list).  I have tried installing the 64bit
drivers but still get errors.

anyone know how i can further investigate the setup on the working server as
to duplicate that working configuration on the new server?   the person who
configured it initially has left the company and cannot be reached to
explain.  thanks in advance, hopefully this thread might help someone else
in this situation down the road.

Responses

pgsql-odbc by date

Next:From: Mike BroersDate: 2009-11-20 20:33:53
Subject: Re: cant get odbc driver to work properly on windows 64 bit
Previous:From: Andreas GaabDate: 2009-11-20 07:55:54
Subject: Re: declare/fetch problem with pgpool 2.2.3; Postgres 8.4; ODBC 8.03.04.00

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group