Knowledgebase
[QODBC-ALL] Troubleshooting - How to convert MS Office from 64-bit to 32-bit
Posted by Jack - QODBC Support on 22 March 2018 12:09 PM

Troubleshooting - How to convert MS Office from 64-bit to 32-bit

Problem Description:

I am on Windows 64-bit and Office 365 64-bit. VB Demo works fine when I use QuickBooks Data as connection source.

If I use QRemote I get the "Evaluation Expired. QRemote requires QODBC license." message.

In Excel, that connection is not available only QuickBooks Data 64-bit QRemote.

Any help would be appreciated.

Solution:

You are not getting QuickBooks Data DSN in the connection window because you are using MS Office 64-bit version.

You can identify if your MS Access/MS Excel is 32-bit or 64-bit from:

MS Office 2010:

File -> Help ->

File -> Help ->

Office 2013:

File -> Account -> About Access

File -> Account -> About Excel

Office 2016/365:

File -> Account -> About Access

File -> Account -> About Excel

In About window. If you see 32-bit, then your MS Office is of 32-bit.

If you see 64-bit, then your MS Office is of 64-bit.

You can identify the application from Task Manager window also.

If the application is 32-bit, then you will notice *32 after EXE name in process tab. If you can't see *32 after EXE name that means the application is of 64-bit.

QuickBooks is a 32-bit application and we must keep QODBC a 32-bit driver to work with QuickBooks and 32-bit applications, both will run under a 64-bit OS.

Since a 64-bit application cannot talk to a 32-bit driver, we have to do a bit of magic to get the worlds to connect, we call it QRemote. QRemote works as a bridge between 64-bit Applications and the 32-bit QODBC Driver by communicating data calls between the two worlds using TCP/IP protocol.

The QBES Read Only version of QODBC will not work with 64-bit applications nor will it work with remote data sharing, that functionality was not part of our contract with Intuit and those functions are only included in the version of the driver we sell.

QODBC Read-only edition for QuickBooks Enterprise does not include QRemote License. So, after 30 days, you will not able to use QRemote.

After 30 days of evaluation, if you try to connect and using QRemote Other then QODBC Licensed you will notice "Evaluation Expired. QRemote requires QODBC license." message.

So, if you want to use QRemote DSN, then you need to purchase a latest QODBC license.

Please click here for purchasing QODBC license.

OR

If you load the 32-bit version of MS Office on the machine you won't have any problems using the driver that we build for Enterprise Solutions.

To install the 32-bit version of MS Office on the machine. First, you need to uninstall 64-bit version of MS Office.

Uninstallation of 64-bit MS Office:

To uninstall 64-bit version of MS Office, search "Control Panel" from Start Menu & click "Control Panel" from the result.

The Control Panel is opened, click "Program and Features" for uninstalling MS Office 64-bit.

From the program list, Search for "Microsoft Office" & click "Uninstall".

MS Office 2010:

Office 2013:

Office 2016/365:

After, MS Office 64-bit version uninstalled you need to install the 32-bit version of MS Office.

Installation of 32-bit MS Office:

MS Office 2010:

You can install 32-bit MS Office by double-click on setup.exe from MS Office 2010 setup folder.

Please make sure that MS Office folder does not contain x64 in the folder name. If x64 in the folder name, then it is the 64-bit installer. You need to use the 32-bit installer.

Office 2013:

In MS Office 2013, You need to navigate to the x86 folder & run setup.exe from MS Office 2013 setup folder.

If you run setup.exe from the main folder, then it will install 64-bit MS Office.

Office 2016/365:

In MS Office 2016/365, You need to navigate to Office folder & run Setup32.exe from MS Office 2016/365 setup folder.

If you run Setup.exe from the main folder, then it will install 64-bit MS Office.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).