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

On 08/10/2016 11:16 PM, catherine.magar@laposte.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.klaver@aklaver.com