[QODBC-POS] How to Configure QODBC POS to Work With 64-bit Applications
Posted by Jack - QODBC Support on 10 November 2016 11:31 AM
How to Configure QODBC POS to Work With 64-bit Applications
64 and 32-bit words are kept separate in the Microsoft Windows Operating System. QuickBooks POS is a 32-bit application, 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 POS 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 POS using QODBC DSN Driver.
Setting Up a New QRemote Connection.
Start QRemote Server for QODBC POS 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
Before creating A DSN entry, verify you have made 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 POS, and click
Configure QODBC POS Data Source 64-bit
"QuickBooks POS Data 64-bit" is the default DSN created when installing QODBC.
Navigate to System DSN. Click on Add Button
From the driver list, selects QRemote for QuickBooks POS and click Finish.
o Under the QRemote for QuickBooks POS 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 needs to be configured at QRemoteServer)
Remote DSN: select the QODBC POS DSN from the list. ( Make sure QRemote Server is running)
In this example, we will be using existing (Default) DSN: QuickBooks POS Data 64-bit.
Verify the QRemote Client connects to the server and that 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 POS via QODBC POS, Start the QRemote server and configure the QRemote Client DSN entry.
Connect using the standard DSN connection string. e.g., DSN=QuickBooks POS Data 64-bit