• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Accessing MS Access 64 bit ODBC with 32 bit PowerBuilder. Possible?

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Accessing MS Access 64 bit ODBC with 32 bit PowerBuilder. Possible?

  1. How-to
0
Votes
Undo
  1. Tom McArdle
    Tom McArdle
  2. PowerBuilder
  3. Tuesday, 25 October 2022 18:40 PM UTC

HI 

I am using a 32 bit version of PowerBuilder.

We have a 64 bit version of MS Access that has the suffix .accdb.

I would like to connect PB to that database. Is it possible using PB?

I do not seem to able to see any 64 bit drivers in PB.

 

 

 

Thank you very much

Tom

Powerclient
conn.Useintegratedwindowsauthentication( True) bad...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 19:06 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tom;

  No, as the PB IDE is 32bit only.

However, you can create a 64bit App EXE from the IDE that could then use the 64bit ODBC driver.

Regards ... Chris

Comment
Tom McArdle
  1. Tom McArdle
  2. Tuesday, 25 October 2022 19:25 PM UTC
That you Chris.

  1. Helpful
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 19:18 PM UTC
  2. PowerBuilder
  3. # 2

get a 32bit ms access driver

 

 

Comment
Tom McArdle
  1. Tom McArdle
  2. Tuesday, 25 October 2022 19:24 PM UTC
Thank You very much for the quick response.

I did try that, but you would need to convert the whole Access Installation to 32 bit.

Microsoft would not let me load the 32 bit driver until I un-installed the 64bit driver.

  1. Helpful
mike S
  1. mike S
  2. Tuesday, 25 October 2022 19:49 PM UTC
create a VM and install the 32bit access driver if you are actually using access on that machine and want the 64 bit version



I don't understand why MSFT makes is so hard to get to access databases. they have made it a real PITA in recent years.
  1. Helpful
There are no comments made yet.
Mark Goldsmith
Mark Goldsmith Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 20:59 PM UTC
  2. PowerBuilder
  3. # 3

Hi Tom,

I'm wondering what version of Office/ MS Access you have but yes, you should be able to do this. Both the 32 bit driver and the 64 bit driver can co-exist on the same machine irrespective of what the bitness is of your MS Access install...but requires specific drivers or a special set of steps:

1) My understanding is that you should be able to install the 2007 Microsoft Access Database Engine alongside the 64 bit drivers, but maybe that engine is too old for you so...

2) This is not intuitive and does potentially involve a registry edit as well as a command line install but a work-around for this is actually outlined by Microsoft. Have a look at this link for the specifics: https://support.microsoft.com/en-us/topic/unable-to-establish-connection-to-access-database-engine-ole-db-in-power-automate-desktop-ed7bb958-3e24-4ff7-9e7e-46cbb9d730c7

Since you already have the 64 bit drivers installed you may only need to do steps 5 and 6.

Here is a snapshot of one of my machines with both drivers installed:

 

HTH...regards,

Mark

Comment
Tom McArdle
  1. Tom McArdle
  2. Wednesday, 26 October 2022 12:01 PM UTC
Thank you so much Mark.

Wonderful information. I will pass this on to our network people and see if that can load both.

They are much better at that than I am. I will let you know how it goes.



  1. Helpful
Tom McArdle
  1. Tom McArdle
  2. Tuesday, 1 November 2022 18:39 PM UTC
HI Mark

I finally got the 32 bit driver to work. I just want to thank yo so much for all your helpful information.



Tom
  1. Helpful
Mark Goldsmith
  1. Mark Goldsmith
  2. Wednesday, 2 November 2022 11:51 AM UTC
You're very welcome Tom and that's great to hear! Thanks for the update and glad that was able to work for you.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.