

Make a note of IP address and Port number listed on the QRemote Server “Event Logs window” Create a new DSN entry/or configure the existing one QRemote Server Main screen shows the IP address and Port it allows the QRemote Client to connect to. ( If QRemoteServer is not running )ĭouble click the QRemote Server icon from the system tray Start “QRemote Server for QODBC Online” from the start menu.

QRemote Server: Processes requested instruction from QRemote Client to QuickBooks Online using QODBC DSN Driver. QRemote Client Driver: Allows 64-bit Applications to connect to QRemote Server and sends the Request to QRemote Server for Processing. QRemote has two components “QRemote Client Driver for QODBC Online” and “QRemote Server for QODBC Online” 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 makes it possible for 64-bit Web Servers and 64-bit applications to talk to QuickBooks live for the first time via the QODBC Driver. 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. QuickBooks is a 32-bit application, so in order to communicate with it, a 32-bit ODBC driver is required. Please Verify that your SQL Server is 64-bit.Ħ4 and 32-bit worlds are kept totally separate in the Microsoft Windows Operating System.

On the Left-hand side panel, you will find the Server, Right Click on the "SQL Server" and Select Properties. Start your "SQL Server Management Studio"
#ONLINE SQL SERVER CLIENT HOW TO#
How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC Online/QRemoteįor 32-bit Refer: How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC Online/QRemote
