Knowledgebase: TroubleShooting
[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 have tested using QODBC Test Tool and the QRemote DSN test connection. I cannot connect to QRemote DSN. I am getting the below error:

Problem Description 2:

I am trying to connect to QRemote Server from my application. The 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 the 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 reasons:

1) QRemote Server is not running.

2) IP/Port in the QRemote client differs from QRemote Server.

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

Please ensure the Version of QRemote on the Client machine is the same QRemote on Server Machine. Please make sure your firewall allows communicating to the 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. Also, try restarting the machine.

4)  Please ensure the Version of QRemote on the Client machine is the same QRemote on Server Machine.

For Example:

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

You can get QODBC latest version from the 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 the same as it is on QRemote Server. You can find the QRemote Server running in System Tray.

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

If it is not running, then please run from the following:

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" and 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 the same as it is on QRemote Server. You can find the QRemote Server running in System Tray. If it is not running, then please run from the following:

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 the following:

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" and 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

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