Thread: How to use a 32bits odbc driver on a 64bits computer ?
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".
Thank you in advance for your help,
Catherine
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
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.klaver@aklaver.com> wrote:
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".
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
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc