Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - QRemote Error "Could not connect to server/QRemoteServer"
Posted by Jack - QODBC Support on 05 June 2015 09:32 AM

Troubleshooting - QRemote Error "Could not connect to server/QRemoteServer"

Problem Description 1:

I cannot connect to QRemote DSN. I have tested using VB Demo application as well as using QRemote DSN test connection. I am getting below error:

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step1.png

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step2.png

Problem Description 2:

I am trying to connect to QRemote Server from my application. Below code hangs on the .open command:

Dim cnQODBC As New System.Data.Odbc.OdbcConnection("DSN=QuickBooks Data 64-Bit QRemote;OLE DB Services=-2;")

Dim daQODBC As System.Data.Odbc.OdbcDataAdapter = New Odbc.OdbcDataAdapter() cnQODBC.Open()

The QODBC server does not show any activity. 

Solutions:

Please follow below steps to resolve the issue.

You will get the message "Could not connect to server" or "Could not connect to QRemoteserver" error due to one of the following reason:

1) QRemote Server is not running.

2) IP/Port in QRemote client is not same as QRemote Server.

3) If you are connecting remotely, then might be a firewall blocking connection.

Please make sure your firewall allows communicating to IP address of QRemoteServer, check if you are using the correct IP address of the remote machine, and also please make sure QRemote is Bind to the same IP address you are using. Please do make sure Version on QRemote on the Client machine is the same QRemote on Server Machine. Also, try restarting the machine.

4)  Please do make sure Version on QRemote on the Client machine is the same QRemote on Server Machine.

For Example:

If client machine QRemote version is 1.0.0.312, then server machine QRemote version also should be 1.0.0.312.
If QRemote version on both machines is different, then please make both versions same by installing same QODBC version on both machines.

You can get QODBC latest version from below link:
QODBC Driver for QuickBooks Download

5) Please verify QRemote is configured correctly.

For 32 Bit QRemote DSN:

Start>> All Programs>>QODBC Driver for use with QuickBooks >> Configure QODBC Data Source >>Go To "System DSN" Tab >> select QuickBooks Data QRemote >> click "configure":

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step3.png



Please verify IP & Port from QRemote Client it should be same as it is on QRemote Server. You can find QRemote Server running in System Tray.

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png

If it is not running then please run from:

Start>>All Programs>> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png

Please verify "Remote DSN" select "QuickBooks Data "DSN from dropdown >> click "Test Connection".

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step4.png

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step6.png



For 64 Bit QRemote DSN:

Please verify your QRemote DSN configuration:

Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source 64-Bit >> Go To "System DSN" Tab >> select QuickBooks Data 64-Bit QRemote >> click "configure":

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png



Please verify IP & Port from QRemote Client it should be same as it is on QRemote Server. You can find QRemote Server running in System Tray. If it is not running then please run from:

Start >> All Programs >> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png

If it is not running then please run from:

Start >> All Programs >> QODBC Driver for use with QuickBooks >> QRemote Server for QODBC

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step5.png

Please verify "Remote DSN" select "QuickBooks Data "DSN from dropdown >> click "Test Connection".

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step6.png

http://support.flexquarters.com/esupport/newimages/QRemoteServer/step6.png

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).