Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - QRemote Server is not returning data to SQL Server
Posted by Jack - QODBC Support on 18 November 2016 11:26 AM

Troubleshooting - QRemote Server is not returning data to SQL Server

Problem Description:

Installed the server connection component, and began the process of reconnecting

Ran a really simple set of tests:

select * from C01...Terms Select * from openquery(C01,'select * from Terms') Insert INTO C01...Terms(name,DayofMonthDue)Values('xyz',1)

None work. The first 2 should return data, and the last one inserts a record. none of this happens.

VB Demo works flawlessly, so I know the DSN is set up correctly.

But none of the above scripts work. The event log shows that a connection is made, but no data retrieval or insert occurs. On the remote machine, the log shows a connection was made each time, but no data was retrieved or processed.

 

 

 

Solution:

You may face this issue when QODBC Version on QuickBooks Application machine is older than QODBC Version on the Client machine.

So you need to make sure that you have same QODBC Version on both Server & Client machine and test again.

You can download & install QODBC latest version by clicking here

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