[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 to 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, Login to your company file as "Admin" and switch to "Single User Mode".

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

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