Troubleshooting - QRemote Server is not returning data to SQL Server
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.
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