How to create a Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC POS/QRemote

Start your "SQL Server Management Studio"

Log in to your SQL Server.

On the left-hand side panel, you will find the Server. Right-click on the "SQL Server" and Select Properties.

Please Verify that your SQL Server is 64-bit.

64 and 32-bit words are kept separate in the Microsoft Windows Operating System. QuickBooks 2021 and older versions are 32-bit applications, so a 32-bit ODBC driver is required to communicate with them.

All versions of QuickBooks from 2002 through 2021 are built on a 32-bit architecture. In contrast, many modern applications—such as Microsoft Excel, Microsoft Access, and Microsoft SQL Server are commonly deployed in 64-bit environments.

For users running QuickBooks 2021 or earlier, this architectural difference creates a compatibility challenge: 64-bit applications cannot directly communicate with 32-bit drivers. To address this limitation, we provide QRemote.

For the users of QuickBooks 2021 or eariler, 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, and we call it QRemote.  QRemote works as a bridge (only for QuickBooks 2022 or lower) 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.

For users running QuickBooks 2022 and later, this additional layer is no longer required. These versions of QuickBooks are native 64-bit applications, and the latest release of the QODBC Driver includes a fully compatible 64-bit driver. As a result, 64-bit applications can connect directly to QuickBooks (using the DSN "QuickBooks Data" ) without the need for QRemote.

QRemote Server is designed to enable connectivity and compatibility across different environments and application types. Its primary use cases include:

1. Service-Based Applications
   QRemote Server is used with service-based applications such as IIS,  SQL Server, PHP, Apache, Windows Services, Data Adapters, and other web server environments where direct interaction with QuickBooks may not be feasible.
2. Remote Connectivity
   QRemote Server allows applications running on a remote machine to connect to QuickBooks hosted on another system, enabling distributed setups and centralized QuickBooks access.
3. 32-bit and 64-bit Compatibility Bridge for QuickBooks 2021 and earlier
   QRemote Server enables 64-bit applications to communicate with 32-bit versions of QuickBooks (2022 and earlier) by bridging the architectural gap between modern applications and legacy QuickBooks environments.

QRemote has two components: "QRemote Client Driver for QODBC" and "QRemote Server for QODBC." 

QRemote Client Driver: Allows service-based applications & 64-bit applications to connect to the QRemote Server and sends the Request to the QRemote Server for Processing.  

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

Start "QRemote Server for QODBC POS" from the start menu. ( If QRemoteServer is not running ) 

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/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.

For 32-bit SQL Server change, QRemote DSN to "QuickBooks POS Data QRemote" is the default DSN created when installing QODBC.

Configure the DSN and provide the IP address and Port as listed under "QRemote Server."

Under the QRemote for QuickBooks – Client  DSN configuration screen, please fill in the following information. 

• Data Source Name: Name of your DSN entry 
• Server: IP address displayed on QRemote Server 
• Port: Port displayed on QRemote Server 
• Encryption Key: Keep default key "QODBC#QRemote$1" (In case you want to use encrypted data transfer between QRemote client and QRemoteServer, you can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN) 

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

Start Your QuickBooks POS.

Run MS SQL 2005 Dev / 2008 / 2012 (64-bit) and log in

    Run SQL Server Management Studio. You'd better choose SQL Server Authentication and input the right name and password. 

Under SQL Server Management Studio, Navigate to "Server Objects" -> Linked Server  -> New Linked Server.

 OR

Provide the "New Linked Server" information.

On clicking OK, it will start establishing a connection to QuickBooks. Please accept the certificate for allowing data access to QuickBooks.

After you have accepted the certificate, the Linked server will be shown under the "Linked Server" Category.

Configure MSDASQL (Microsoft OLE DB Provider for ODBC Drivers)

   The OLE DB provider options for managing linked queries can be set in SQL Server Management Studio. In Object Explorer, right-click the provider name and select Properties for MSDASQL.

The dynamic parameter should be checked to allow parameter queries. Level zero should only be checked to enable four-part naming to work. Allow InProcess should be checked to help performance. Non-transacted updates should be checked if you want to be able to update QuickBooks data. The index as an access path should be checked to help performance. Disallow ad hoc accesses should be unchecked to allow OPENQUERY to function.

QODBC/QRemote is ready to use with SQL Server/Linked Server

Execute below query

Select * from qremote…customer

On each query, the QRemote Server logs the events. If you are facing any issues or delays in response, please refer to the QRemote Server Event Logs for details on which stage is taking more time.

Another Test

Select * from qremote…employee

On each query, the QRemote Server logs the events. If you are facing any issues or delays in response, please refer to the QRemote Server Event Logs for details on which stage is taking more time.

Errors and Solutions 

"[QODBC-POS] QODBC-POS  Server Edition License Required."

The QODBC CDKEY License you have activated is not of the Server edition. Please get in touch with our Sales or Support team. http://support.flexquarters.com/esupport/

“[QODBC-POS] Evaluation Expired”

You have run out of the 30-day trial/evaluation version. If you still wish to evaluate QODBC, please get in touch with our Sales team.

"QRemote" or "QODBC" contains multiple tables that match the table "TableName."

This means you have not configured the "MSDASQL" provider. Please refer to the above steps and configure the "MSDASQL" provider.

"[QODBC-POS] Unable to Open License File"

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

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

Now, please click the certificate." It should display a table list.

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

You will receive a Test Connection success message.

Also, refer to

Using QuickBooks data with MS SQL Server using QODBC Driver and QRemote (Video)

QODBC Reports Architecture Mismatch Problem When connecting

Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video)

Keywords: SQL Server 2008 Management Studio, SQL Server 2016 Management Studio, SQL Server 2012 Management Studio, SQL Server Management Studio, SSMS