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 words are kept separate in the Microsoft Windows Operating System. QuickBooks 2022 and above are 64-Bit applications and include both a 32-Bit and a 64-Bit QuickBooks SDK interface.

QODBC 2023 now includes a 64-Bit driver and the 32-bit driver, so you can use 64-bit or 32-bit applications to connect to QuickBooks Data directly. QRemote is no longer required to connect 64-bit applications with our 32-bit driver and is now used mainly for remote connection situations.

Service-based applications such as Web Server, SQL Server, or Windows Services still need to use QRemote Driver because QuickBooks cannot be run as a service.

For QuickBooks 2021 and older or service-based applications or remote connection:

QuickBooks 2021 and older versions are 32-bit applications, so a 32-bit ODBC driver is required to communicate with it.

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. QRemote allows 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 allowing the QRemote Client to connect.

Note the 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

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

·         Server: IP Address displayed on QRemote Server 

·         Port: Port displayed on QRemote Server 

·         Encryption Key/Password: (By Default, Encryption Key/Password is set to "QODBC#QRemote$1". In case you want to change your Encryption Key/Password, You can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN) 

·         Encryption(By Default, Encryption is set to Off. In case you want to use encrypted data transfer between QRemote client and QRemoteServer, You can configure encryption on QRemoteServer and use the same on QRemote Client DSN) 

·         Remote DSN: select QuickBooks Data 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)

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

Note: If you are using "QODBC POS," then. Please refer to the below steps

Please use "QuickBooks POS Data 64-bit" DSN or use the connection string DSN=QuickBooks POS Data 64-bit; OLE DB Services=-2;

Please click on "Test Connection." It will start establishing a connection to QuickBooks. Please accept the certificate for allowing data access on QuickBooks.

Now please click on "Run" It should display a table list.

Now please test the connection on the linked server by right click on the linked server name. Please click on "Test Connection."

You will receive a Test Connection success message.

 

Start the "QODBC 64-Bit Test tool" application from the start menu.

 

Click on the "Drop-down Menu"

Select DSN

For example: "QuickBooks Data 64-Bit QRemote

Click on the "Connect" button

Write down the query in the marked field. Please refer to the image below.

For example:

Select * from Customer

Click on the "Run" button.

 

 

 

 

 

 

 

 

(8 vote(s))
Helpful
Not helpful

Comments (8)
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
Khandad
17 December 2017 03:24 PM
we can access to QUick books enter 2018 Through QB Remote Local area network and wide area network ?
Jack
19 December 2017 09:16 AM
Hi,

If your QuickBooks application is installed on another machine, then you can connect to QuickBooks from a remote machine using QRemote Server. You need to install QODBC on both machines.

Please refer below mentioned article for Accessing QuickBooks Data Remotely using QODBC &QRemote. (Video):
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/

You need to run QRemote Server on QuickBooks machine & try to connect from your workstation using QRemote Client. QRemote Client should point to QuickBooks Server IP & Port.
Jesse Wysong
16 January 2018 10:31 PM
Hello,
I am trying to access my Quickbooks data via Power BI. Is this even possible? Quickbooks Data 64-bit QRemote is available via the DSN pull down menu. It loads the list of tables but then generates an error when I click on a table to look at the fields.

Power BI Error:

DataSource.Error: ODBC: ERROR [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support this parameter
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=QuickBooks Data 64-Bit QRemote
OdbcErrors=Table

Thank you,
Jack
17 January 2018 10:34 AM
Hi Jesse,

I would like to inform you that QODBC is not supported to the Power BI desktop. Normally we suggest using MS Access as middleware in QODBC unsupporting application. But in this case, middleware also not working because Power BI is not able to fetch MS Access linked table.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2584/45/how-to-use-ms-access-as-middleware-with-qodbc

You can dump QuickBooks data in MS Access.

Import the source data into a new table in the current database, this option will directly extract tables into Access Database, you can view and edit these tables but all modification will not be uploaded unless you build another query to do so.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2448/0/how-to-use-qodbc-with-microsoft-access-2007

If you are still the facing issue, Please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, Please attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Refer: How to take screenshot: www.qodbc.com/links/screenshot.htm
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).