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

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