Troubleshooting - QRemote Server is not returning data to SQL Server
Problem Description:
Installed the server connection component and began the process of reconnecting
I 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 two should return data, and the last should insert a record. None of this happens.
QODBC Test Tool works flawlessly, so I know the DSN is set up correctly.
But none of the above scripts work. The event log shows a connection, but no data retrieval or insert occurs. The record shows a connection was made each time on the remote machine, but no data was retrieved or processed.
Solution:
You may face this issue when QODBC Version on the QuickBooks Application machine is older than QODBC Version on the Client machine.
So you need to ensure that you have the same QODBC Version on both Server & Client machines and test again.
You can download & install QODBC's latest version by clicking here.
|