Knowledgebase
[QODBC-ALL] How to Configure QODBC to Work With 64-bit Applications
Posted by Wilson (QODBC Support) on 23 March 2012 07:42 AM

How to Get QODBC to go with 64-bit Applications

How to Configure QODBC to Work With 64-bit Applications

Instructions

64 and 32-bit worlds are kept totally separate in the Microsoft Windows Operating System. QuickBooks is a 32-bit application, so in order to communicate with it, a 32 bit ODBC driver is required.

Since a 64bit 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 64Bit Applications and the 32 Bit QODBC Driver by communicating data calls between the two worlds using TCP/IP protocol. QRemote makes it possible for 64 bit Web Servers and 64 Bit applications to talk to QuickBooks live for the first time via the QODBC Driver.

QRemote has two components QRemote Client Driver for QODBC and QRemote Server for QODBC?

QRemote Client Driver: Allows 64 Bit Applications to connect to QRemote Server and sends the Request to QRemote Server for Processing.

QRemote Server: Processes requested instruction from QRemote Client to QuickBooks using QODBC DSN Driver.

Setting Up A New QRemote Connection.

Start QRemote Server for QODBC?from the start menu.

Double click the QRemote Server icon from the system tray.

QRemote Server Main screen, shows the IP address and Port it allows the QRemote Client to connect to.

Make a note of IP address and Port number listed on the QRemote Server Event Logs window

Create a new DSN entry

o Before creating A DSN entry verify you have created a DSN entry for QODBC which can connect to QuickBooks. 

Create a new DSN entry/or configure the existing one

Navigate to Start Menu, QODBC Drivers for Use with QuickBooks and click

Configure QODBC Data Source 64-Bit 

QODBCStartMenu.png

 

"QuickBooks Data 64-Bit QRemote" is the default DSN created when installing QODBC. (Earlier it was
“QRemote Data 64-bit”)

 

o Navigate to System DSN. Click on Add Button

o From the driver, list select QRemote for QuickBooks and click Finish

o Under the QRemote for QuickBooks Client DSN configuration screen, Please fill in the following information

o Data Source Name : Name of your DSN entry

o Server : IP address displayed on QRemote Server

o Port : Port displayed on QRemote Server

o Encryption Key: ( Optional, required only if you want to encrypt the data transfer, also need to be configured at QRemoteServer)

Remote DSN: select the QODBC DSN from the list. ( Make sure QRemote Server is running)

In this example, we will be using existing (Default) DSN: QuickBooks Data 64-Bit QRemote  

Earlier (QRemote Data 64-Bit)

 

o Verify the QRemote Client connects to the server and the below-listed logs are logged in the event window.

 

Connecting with 64 Bit Applications

To allow 64 Bit Application(s) to talk to QuickBooks via QODBC, Start the QRemote Server and configure the QRemote Client DSN entry.

 

Connect using the standard DSN connection string. e.g. DSN=QuickBooks Data 64-Bit QRemote

 

(8 vote(s))
Helpful
Not helpful

Comments (4)
Sylvain
04 February 2013 08:14 PM
We are using the qODBC version that ships with QB Enterprise.
Where can I find QRemote?
Jerry
19 February 2013 07:41 PM
How to get the Q Demo DotNET (BETA) to test connection, and where did I get the date file Customer.
Thanks so much for your help
Komal
18 August 2013 11:39 PM
Can you give us the link to download Q Demo DotNET (BETA) to test connection?
Rajendra Dewani
21 September 2013 07:27 AM
Here is the link of QDemo :
http://support.flexquarters.com/esupport/supportfiles/QDemo.zip
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).