Re: How to use a 32bits odbc driver on a 64bits computer ?

And don't forget, you can't see the installed 32 bit odbc drivers on a 64 bit machine unless you run the 32 bit viewer at:
C:\Windows\SysWOW64\odbcad32.exe

>>> On 8/11/2016 at 6:21 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
On 08/10/2016 11:16 PM, catherine(dot)magar(at)laposte(dot)net wrote:
> Hello,
>
> I would like to enable a 32 bits program to communicate with my psql
> database on a 64bits PC via a .dsn file. Problem is, when I try to
> create the dsn file, I've only access to 64bits ODBC drivers.
> I tried to uninstall and install again 32bits ODBC drivers available
> here https://www.postgresql.org/ftp/odbc/versions/msi/. I've tried

> several versions (psqlodbc_09_05_0300, psqlodbc_09_05_0300-x86,...).
> How can I force my computer to use the 32bits version instead of 64bits ?
> Or is there any driver only for 32bits ?
>
> I've already managed to open the communication with same program and
> database on other computers; among them a 64 bits computer which let me
> choose in "control panel->administrative Tools->ODBC data source
> administrator 32 bits "or "->ODBC data source administrator 64 bits".

https://odbc.postgresql.org/faq.html#6.8

How to configure 32 bit ODBC drivers on Win x64

Configure ODBC DSN from %SystemRoot%\syswow64\odbcad32.exe. Click

Start->Run
Enter: %SystemRoot%\syswow64\odbcad32.exe
Hit return
>
> Thank you in advance for your help,
> Catherine

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com