Knowledgebase: QODBC
[QODBC-Desktop] How to create or configure a QRemote DSN
Posted by Jack - QODBC Support on 23 January 2018 09:08 AM

How to create or configure a QRemote DSN

Launch QODBC Data Source Configuration

      Locate the QODBC Driver for QuickBooks program group from Startup Program: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

Create a New 32-bit DSN

      Click on the System DSN tab to create a DSN that can be called by both Windows applications and services. Click on the Add button to create a new DSN.

       Select the QRemote for QuickBooks option and click on the Finish button.

Configure the Created 32-bit DSN

      Under the QRemote for QuickBooks Client DSN configuration screen, Please fill in the following information

·         Server: IP Address displayed on QRemote Server 

·         Port: Port displayed on QRemote Server 

·         Encryption Key/Password: (By Default Encryption Key/Password is set to "QODBC#QRemote$1". In case you want to change Encryption Key/Password, You can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN) 

·         Encryption(By Default Encryption is set to Off. In case you want to use encrypted data transfer between QRemote client and QRemoteServer, You can configure encryption on QRemoteServer and use the same on QRemote Client DSN) 

·         Remote DSN: select QuickBooks Data DSN from the list. (Make sure QRemote Server is running)  

      After filling all the details click "Test Connection" for testing the QRemote connection.

      Test connection is successful.

      Click "OK" to save DSN configuration.

      New DSN created. Close the ODBC Manager by clicking "OK".

      The new QODBC DSN has now been created. To modify the DSN anytime in the future, use the Configure button.

Create a New 64-bit DSN

      Navigate to Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-bit

      Click on the System DSN tab to create a DSN that can be called by both Windows applications and services. Click on the Add button to create a new DSN.

       Select the QRemote for QuickBooks option and click on the Finish button.

Configure the Created 64-bit DSN

      Under the QRemote for QuickBooks Client DSN configuration screen, Please fill in the following information

·         Server: IP Address displayed on QRemote Server 

·         Port: Port displayed on QRemote Server 

·         Encryption Key/Password: (By Default Encryption Key/Password is set to "QODBC#QRemote$1". In case you want to change Encryption Key/Password, You can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN) 

·         Encryption(By Default Encryption is set to Off. In case you want to use encrypted data transfer between QRemote client and QRemoteServer, You can configure encryption on QRemoteServer and use the same on QRemote Client DSN) 

·         Remote DSN: select QuickBooks Data DSN from the list. (Make sure QRemote Server is running)  

      After filling all the details click "Test Connection" for testing the QRemote connection.

      Test connection is successful.

      Click "OK" to save DSN configuration.

      New DSN created. Close the ODBC Manager by clicking "OK".

      The new QODBC DSN has now been created. To modify the DSN anytime in the future, use the Configure button.

Also, Refer:

How to create or configure a QODBC DSN

(0 vote(s))
Helpful
Not helpful

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