10/29/2022 0 Comments Point of sale quickbooks tutorial
In this example, we are using QODBC POS Test Tool You may use any 32-bit Application like MS Access/Excel to connect to the Remote QODBC. Verify the QRemote Client connects to the server and the below-listed logs are logged in the event window of QRemote Server at SERVER Machine:Ĭonnection to Remote QuickBooks POS/QODBC POS via Applications (32-bit) (For 64-bit DSN, "QuickBooks POS Data 64-bit") This is the QODBC DSN on the SERVER Machine ( Make sure QRemote Server at SERVER Machine is running). Remote DSN: select the QODBC DSN from the list. Port: Port displayed on QRemote Server at SERVER MachineĮncryption 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) Server: Change the IP Address to the IP address displayed on QRemote Server at SERVER Machine, e.g., 192.168.1.19 Fill in the following informationĭata Source Name: Name of your DSN entry - Do Not Change This will bring QRemote Client DSN Configuration. (For 64-bit DSN, "QuickBooks Data 64-bit QRemote" or "QRemote Data 64-bit")Ĭlick Configure. Switch to "System DSN", Select the DSN "QuickBooks Data QRemote" Or "QRemote Data 32-bit". (If your application is 64-bit, select "Configure QODBC POS Data Source 64-bit)" POINT OF SALE QUICKBOOKS TUTORIAL WINDOWSSelect "Configure QODBC POS Data Source" from Windows Start Menu. Make a note of the IP address and port number listed on the QRemote Server. QRemote Server Main screen shows the IP address and port setup for the QRemote CLIENT to connect to. Start "QRemote Server for QODBC" from the Windows start menu.ĭouble click the QRemote Server icon " Q" from the system tray. POINT OF SALE QUICKBOOKS TUTORIAL DRIVERQRemote Server ( SERVER): Processes requested instructions from QRemote Client to QuickBooks POS using QODBC Driver talking to QuickBooks POS application SDK. QRemote Client Driver ( CLIENT): Allows applications to connect to QRemote Server and sends the Request to QRemote Server for Processing. QRemote has two components, "QRemote Client Driver for QODBC POS" and " QRemote Server for QODBC POS" QRemote works as a bridge between remote applications and the QODBC POS Driver by communicating data calls between the two worlds using TCP/IP (Internet) protocol. The tool we use to do this remote connection is called QRemote. Once this is done, a few simple settings in the driver setup screen are all that is required to use this data remotely.īefore testing remote capabilities, be sure you have tested basic QODBC POS functionality to ensure that QODBC POS can connect to QuickBooks POS and obtain data with this article. QuickBooks POS on the SERVER Machine should be able to open the QuickBooks POS company file. It does not matter if the QuickBooks POS data file is located on the SERVER machine or another location, but the best speed is attained if it is on the SERVER machine. POINT OF SALE QUICKBOOKS TUTORIAL INSTALLTo get this feature to work, simply install QODBC POS on the machine which runs QuickBooks POS (the SERVER), and the machine you want to use the data from (the remote CLIENT). This feature can transfer data in an unencrypted fashion (plain text), or you can set up your own encryption key to encrypt the data, which is preferable for transfer over the open Internet. This feature is built-in to the licensed version and requires no additional charge. QODBC POS has the ability to talk to a copy of QuickBooks POS running anywhere in the world over the Internet, or over a local area network. QRemote Tutorial: Using QuickBooks POS data remotely via QODBC POS Posted by Jack - QODBC Support on 10 November 2016 10:59 AM
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |