Postgres Pro
Downloads
Home   >   mailing lists

Thread: 64 Bit versus 32 Bit

64 Bit versus 32 Bit

From
Cevin A Moses
Date:
Good afternoon,
    I’m not sure if you can help me, but maybe at least shed some light on things.  I have a MS-Access database used by
6-7different users.  It mostly uses an MS-Access backend, but there are some connections to a PostgreSQL server as
well. It was built with MS-Access 2010 32-bit because we still had a few 32-bit WinXP machines floating around.  I used
thePostgreSQL Unicode driver, version 9.01.01.00, and configured the connection with Window’s ODBC Data Source
Administrator(32-bit).  It has been working for several years. 
    Now that all of the computers have all been upgraded, some of the newer ones are getting Office 365 64-bit
installed. When they open the database with a 64-bit version of Access, the ODBC connections fails.  If I reinstall the
32-bitruntime version of MS-Access to open the file, everything works fine.  However, I have tried installing the
64-bitPostgreSQL driver, version 11.00.00.00, but Access 64-bit still gives me the same error.  The 64-bit ODBC
connectiontest within the ODBC Data Source Administrator (64-bit) says that it is successful, but 64-bit Access still
can’topen it.  I don’t know if I can have both the 32-bit and the 64-bit drivers installed and setup with the same
networkconnections or not.  I’m not sure if there’s anything within the Access database file that’s directing it to use
the32-bit connection, but the 64-bit version of Access doesn’t like it, or what. 
    If you can shed any light on this I would appreciate it.  Might be more of an Access-side question, but I thought
I’dreach out just in case. 

Thanks,

Cevin Moses
cevin@imoses.com
262-203-3895

Re: 64 Bit versus 32 Bit

From
Cevin A Moses
Date:
Good afternoon,
I took a fresh Windows installation and installed just the 64-bit driver.  The machine has Office 365 (64-bit) installed.  I created the ODBC connection, which tested fine.  Then I created a new database and tried to setup a linked table using that ODBC connection, but the connection is not listed.  Here is a screen shot from the 64-bit machine:



And here is the same process on the 32-bit version of Access using the 32-bit ODBC driver.



As you can see, the connection is visible within Access in the 32-bit version, but the 64-bit version of Access cannot see the 64-bit ODBC connection as an option.

Might be a driver issue or an issue with Access, but it has nothing to do with my database file itself.  At least I’ve ruled that part out.

Thanks,
Cevin



On Apr 11, 2019, at 4:27 PM, Cevin A Moses <Cevin@iMoses.com> wrote:

Good afternoon,
I’m not sure if you can help me, but maybe at least shed some light on things.  I have a MS-Access database used by 6-7 different users.  It mostly uses an MS-Access backend, but there are some connections to a PostgreSQL server as well.  It was built with MS-Access 2010 32-bit because we still had a few 32-bit WinXP machines floating around.  I used the PostgreSQL Unicode driver, version 9.01.01.00, and configured the connection with Window’s ODBC Data Source Administrator (32-bit).  It has been working for several years.
Now that all of the computers have all been upgraded, some of the newer ones are getting Office 365 64-bit installed.  When they open the database with a 64-bit version of Access, the ODBC connections fails.  If I reinstall the 32-bit runtime version of MS-Access to open the file, everything works fine.  However, I have tried installing the 64-bit PostgreSQL driver, version 11.00.00.00, but Access 64-bit still gives me the same error.  The 64-bit ODBC connection test within the ODBC Data Source Administrator (64-bit) says that it is successful, but 64-bit Access still can’t open it.  I don’t know if I can have both the 32-bit and the 64-bit drivers installed and setup with the same network connections or not.  I’m not sure if there’s anything within the Access database file that’s directing it to use the 32-bit connection, but the 64-bit version of Access doesn’t like it, or what.
If you can shed any light on this I would appreciate it.  Might be more of an Access-side question, but I thought I’d reach out just in case.

Thanks,

Cevin Moses
cevin@imoses.com
262-203-3895

Attachment

RE: 64 Bit versus 32 Bit

From
"Regina Obe"
Date:
> I took a fresh Windows installation and installed just the 64-bit driver.
>   The machine has Office 365 (64-bit) installed.
I know you said you have 64-bit Office 365 installed.  Are you absolutely sure of that?
I know this happened to me when I accidentally installed the 32-bit on my 64-bit box.

To verify if you go into the start menu and see where it's pointing, your MSAccess.exe should in

C:\Program Files\Microsoft Office\....
(if it's in C:\Program Files (x86) then it's the 32-bit version)

Mine happens to be in

C:\Program Files\Microsoft Office\root\Office16\msaccess.exe



Hope this helps,
Regina

RE: 64 Bit versus 32 Bit

From
Danny Severns
Date:

I have had a similar problem and discovered that the ODBC Admin listing invoked from Control Panel > Admin Tools, is the 32-bit version.  To set it up in the 64-bit ODBC Admin, go to the Start > Run and enter \windows\SysWOW64\odbcad32.exe.  If it is like my situation, you will not see your DB set up listed, but the Driver should be installed.  If so, then add your db instance to the System DSN then your ODBC compliant apps should be able to see it and connect to it.

HTH

Danny

 

 

From: Cevin A Moses <cevin@imoses.com>
Sent: Thursday, April 11, 2019 4:46 PM
To: pgsql-odbc@postgresql.org
Subject: Re: 64 Bit versus 32 Bit

 

Good afternoon,

                I took a fresh Windows installation and installed just the 64-bit driver.  The machine has Office 365 (64-bit) installed.  I created the ODBC connection, which tested fine.  Then I created a new database and tried to setup a linked table using that ODBC connection, but the connection is not listed.  Here is a screen shot from the 64-bit machine:

 

 

 

And here is the same process on the 32-bit version of Access using the 32-bit ODBC driver.

 

 

 

As you can see, the connection is visible within Access in the 32-bit version, but the 64-bit version of Access cannot see the 64-bit ODBC connection as an option.

 

Might be a driver issue or an issue with Access, but it has nothing to do with my database file itself.  At least I’ve ruled that part out.

 

Thanks,

Cevin

 

 

 

On Apr 11, 2019, at 4:27 PM, Cevin A Moses <Cevin@iMoses.com> wrote:

 

Good afternoon,
                I’m not sure if you can help me, but maybe at least shed some light on things.  I have a MS-Access database used by 6-7 different users.  It mostly uses an MS-Access backend, but there are some connections to a PostgreSQL server as well.  It was built with MS-Access 2010 32-bit because we still had a few 32-bit WinXP machines floating around.  I used the PostgreSQL Unicode driver, version 9.01.01.00, and configured the connection with Window’s ODBC Data Source Administrator (32-bit).  It has been working for several years.
                Now that all of the computers have all been upgraded, some of the newer ones are getting Office 365 64-bit installed.  When they open the database with a 64-bit version of Access, the ODBC connections fails.  If I reinstall the 32-bit runtime version of MS-Access to open the file, everything works fine.  However, I have tried installing the 64-bit PostgreSQL driver, version 11.00.00.00, but Access 64-bit still gives me the same error.  The 64-bit ODBC connection test within the ODBC Data Source Administrator (64-bit) says that it is successful, but 64-bit Access still can’t open it.  I don’t know if I can have both the 32-bit and the 64-bit drivers installed and setup with the same network connections or not.  I’m not sure if there’s anything within the Access database file that’s directing it to use the 32-bit connection, but the 64-bit version of Access doesn’t like it, or what.
                If you can shed any light on this I would appreciate it.  Might be more of an Access-side question, but I thought I’d reach out just in case.

Thanks,

Cevin Moses
cevin@imoses.com
262-203-3895

 

Attachment

Re: 64 Bit versus 32 Bit

From
Clemens Ladisch
Date:
Danny Severns wrote:
> To set it up in the 64-bit ODBC Admin, go to the Start > Run and enter \windows\SysWOW64\odbcad32.exe.

Actually, \windows\system32\odbcad32.exe is the 64-bit version,
while \windows\syswow64\odbcad32.exe is the 32-bit version.


Regards,
Clemens