[QODBC-Desktop] Using QuickBooks data remotely via QODBC with SQL Server 64-bit
Posted by Rajendra Dewani (QODBC Support) on 24 December 2012 06:20 AM

QODBC can allow SQL Server to Access QuickBooks Data Remotely.

"FileServer": having QuickBooks File
"Server": having QuickBooks Application
"Client": having SQL Server.

Below are the Steps

Install QODBC on "Server" & "Client."  Not required on "FileServer."

"Server": Start QuickBooks, log in to your company file as "Admin," and switch to "Single User Mode."

Configure QRemote Related DSN on "Client" Machine to Point to "Server" QRemoteServer. 

Configure SQL Server (Linked Server). 


( Skip the QRemote DSN Setup as you have already configured it before starting the SQL Linked Server Steps).

For 32-bit SQL Server use, "QRemote Data 32-bit."
For 64-bit
SQL Server use"QRemote Data 64-bit."

Please note: From QODBC and upwards, QRemote related DSN Name is changed to

For 32-bit SQL Server use, "QuickBooks Data QRemote."
For 64-bit
SQL Server use"QuickBooks Data 64-bit QRemote."

If you get an error, please search our FAQ Knowledge-base or post a support ticket to resolve the issue.

Also, Refer

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


Keywords: qodbc installed on QuickBooks server

(1 vote(s))
Not helpful

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