64 Bit Toad and 32 Bit Access

Toad for Oracle
1

Of course the company I work for is in panic about moving to Window 7 from XP. We loaded 64 bit Toad (12.1.0.22) onto a Win7 computer. We get the following error trying to export to Access: “Could not load the Microsoft Access Database Engine. This is not the full Microsoft Access product, just the redistributable engine. It must be the same bit version (32 or 64) as Toad.” Exporting to Excel works fine. We are looking into getting the 64 bit redistributable engine. If we have to go back to 32 bit Toad, what Toad limitations are we facing under Win7? Is there a Blog or paper discussing this issue? If so, where is it located?

Thanks,
Dave

2

Of course as soon as I hit post, I noticed the title should be 32 Bit Access.

4

John:

We tried the suggested workaround, but got the same error.

Dave

5

Oh, sorry - I misunderstood your question. Yes, the bitness of Access must match the bitness of Toad for this to work. I guess you have the 32 bit version of MS Office installed. I can’t remember for sure if you can have the 64 bit ms access database installed along side the 32 bit ms office. I think you can’t but maybe I am remembering this wrong.

In any case, to answer your question - It’s fine to run 32 bit Toad in 64 bit windows. The only time you might run into problems is when you try to pull so much data into your grids that Toad’s memory usage approaches 2Gb.

6

Just make sure that if you decide to run 32-bit toad on windows 64-bit that you use the 32-bit oracle client. See my blogs on this :slight_smile:

www.toadworld.com/…/running-toad-for-oracle-in-a-64-bit-environment-updated.aspx

7

Bert:

Just what I needed along with John’s comment. IT installed both 32bit and 64bit clients (c:\Oracle_x64 and c:\Oracle_x32). Our ORACLE_HOME in the registry uses the 64bit path. So a 64bit client maps to 64bit Toad. (We really don’t want to change the installation process. We have enough issues.) If an Access file is needed, we will use Excel as an intermediate step.

If for some reason we have to go to the 32bit client, would we just have to change the registry?

Thanks,

Dave

8

If for some reason we have to go to the 32bit client, would we just have to change the registry?

No. Toad will detect the clients that match its bitness and ignore the ones that don't.

9

John:

Does Toad then update ORACLE_HOME and other keys in the registry appropriately?

Dave

10

No, it doesn’t need to. It just uses whichever Oracle home is selected on the login screen – and it will be auto-selected if there is only one of the same bitness as Toad.

12

The author's first reply in the thread:

Of course as soon as I hit post, I noticed the title should be 32 Bit Access

13

I’ve updated the title of the thread so that it’s accurate…

14

Maybe if tittle’s phrase “Access is” changed to “MS Access” this would be a little more clear for everyone in search …

[:D][:D]

15

I just installed Toad for Oracle 12.7 64-bit and also installed the full MS Office Access 64-bit. When downloading and exporting to Ms Access, I was getting the error ‘Could not load the Microsoft access Database Engine…’

I have both Toad and MS Office/MS Access 64-bit version. Does somebody encountered the same problem? I’m using Windows 7.

16

It should work if you have 64 bit Toad and 64 bit MS Access installed.

However, you could try going here to download the MS Access Database Engine - be sure to double-check your Toad bit version and get the matching one from this page.

www.microsoft.com/…/details.aspx

17

Thanks. I'm pretty sure I have 64-bit for Toad and MS Access 2013.

I will download and install the 64-bit ms access database engine. I will let you know of the results.

Thanks again.

*Celedonio 'Jun' Bausa

18

I worked. I just need that ms access database engine installed.

Thanks a lot.

Celedonio 'Jun' Bausa
Orleans Parish Assessor's Office**T-504-658-1346

19

Hi, Community.

I know this post is about 3.5 years old, but I have a business requirement to export a lot of data to MS Access. I have installed TOAD 11.6, 64-bit on my Windows machine, as well as the 64-bit MS Access Engine. I still get the same error referenced in the original post. Perhaps this is a dumb question, but:

Is MS Office required to be installed on the machine along with TOAD and the MS Access Engine? I get that you would need office to open the .mdb file, but could you still export the data and create the .mdb file without MS Office on the TOAD machine?

Thank you for your help.

20

You shouldn’t need all of MS Access, just the runtime. Here are some links to the different versions. Toad 11.6 came out in 2012, so your best bet is probably the 2010 version but maybe the 2013 version would work too. You might have problems with the 2016 since it is so much newer than your version of Toad.

2010: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255

2013: https://www.microsoft.com/en-us/download/details.aspx?id=39358

2016: https://www.microsoft.com/en-us/download/details.aspx?id=50040

21

Hi, John.

Thank you very much for your help. I installed the 2010 version of the MS Access DB Engine (first link; AccessDatabaseEngine_X64.exe). I also confirmed that my TOAD version is 64-bit (the support information is below). I also installed Office 2010 64-bit, version 14.0.7015.1, just for good measure. Unfortunately, I still get the same error as soon as I try to export my dataset to “Access Database File.” It’s almost like TOAD can’t find the MS Access Database Engine.

Do I have to configure anything in the Access Db Engine after I install it? Do I need to point TOAD to the Access Db Engine?

I appreciate everyone’s help.

TOAD Support information:

APPLICATION INFORMATION - FULL VERSION (64-bit)

Support Bundle for Toad for Oracle 11.6.0.43
Bundle: Toad for Oracle Xpert (64-bit) Add-Ons: DB Admin Module
Toad for Oracle Executable Location : C:\Program Files\Quest Software\Toad for Oracle 11.6\Toad.exe
QSEServer DLL Location : C:\Program Files\Quest Software\Toad for Oracle 11.6\qse.dll
QSEServer Version : 11.6.0.43
QP5 DLL Location : C:\Program Files\Quest Software\Toad for Oracle 11.6\QP5.dll
QP5 Version : 5.227.12220.39754
QP5CA DLL Location : C:\Program Files\Quest Software\Toad for Oracle 11.6\QP5CA.dll
QP5CA Version : 5.227.12220.42377
TOAD Policy Location : C:\Program Files\Quest Software\Toad for Oracle 11.6\Toad.pdl

TEAM CODING

MANAGED ITEMS

Not a managed environment.

ORACLE CLIENT INFORMATION

Oracle Client Version : 11.2.0.2
Oracle Client DLL : C:\app\oracle\product\11.2.0\client_ora11r2_x64\BIN\oci.dll
TNSNAMES.ora Location : C:\app\oracle\network\admin\tnsnames.ora
NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH : C:\app\oracle\product\11.2.0\client_ora11r2_x64\dbs
LOCAL :

ORACLE SERVER INFORMATION

Connection 1 : Oracle Database ** Active Session **
Oracle Server Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Oracle Server NLS_CHARACTERSET : NLS_CHARACTERSET
Oracle Server NLS_NCHAR_CHARACTERSET : NLS_NCHAR_CHARACTERSET
Oracle Session User : User (Normal)

SYSTEM INFORMATION

Operating System : Windows Server 2008 (Build 7601) Service Pack 1
Is Terminal Server: No
Using XP Theme: No

Physical Memory Load : 33.77 %
Physical Memory (Total) : 4095 MB
Physical Memory (Free) : 2712 MB
Virtual Memory (Total) : 8388607 MB
Virtual Memory (Free) : 8388080 MB
Swap Space (Total) : 12485 MB
Swap Space (Free) : 11094 MB
Toad Page File Usage (Virtual Memory) : 237 MB
Toad Working Set Usage (RAM) : 237 MB

Environment Variable (PATH) :
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0
C:\App\Oracle\product\11.2.0\client_ora11r2_x64\bin
C:\App\Oracle\product\11.2.0\client_ora11r2_x86\bin

Environment Variable (TNS_ADMIN) : TNS_ADMIN is not a declared environment variable.

ORACLE HOMES DATA

(Oracle Root)
inst_loc = C:\app\Oracle\Inventory\OraClient11gR2_x64
KEY_OraClient11gR2_x64 ***** This is the home currently used by Toad *****
ORACLE_HOME = C:\app\oracle\product\11.2.0\client_ora11r2_x64
ORACLE_HOME_NAME = OraClient11gR2_x64
ORACLE_GROUP_NAME = Oracle - OraClient11gR2_x64
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\app\oracle\product\11.2.0\client_ora11r2_x64\oledb\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11gR2_x64
MSHELP_TOOLS = C:\app\oracle\product\11.2.0\client_ora11r2_x64\MSHELP
SQLPATH = C:\app\oracle\product\11.2.0\client_ora11r2_x64\dbs
TNS_ADMIN = C:\app\oracle\network\admin

OraClient11gR2_x64
C:\app\oracle\product\11.2.0\client_ora11r2_x64\bin exists
C:\app\oracle\product\11.2.0\client_ora11r2_x64\bin is in PATH
Home is valid

22

No, you shouldn’t have to do anything after it’s installed.

but…

I happen to have a VM with Toad 11.6 64 bit (and no MS Office of any kind), so I gave it a try with the 2010 engine. And it didn’t work for me either. After a bunch of scratching my head and googling, I found a page where someone noticed that the DLL was being installed to

C:\Program Files (x86)\Common Files\microsoft shared\DAO

so the guy copied that folder to

C:\Program Files\Common Files\Microsoft Shared\DAO

and suddenly it started working! So I tried that, and it worked for me too. Give it a shot.