We are having problems running remote reports to a Sybase ASE. We have two MyDBR instances in the same Apache. One using MySQL (where all users access reports) and one using ASE.
We can run remote reports from the MySQL instance but only if the result set from the ASE reports have a limited numbers of rows or if we add top 1000 to the query.
The error we are shown is:
"No return value from remote query:"
If we enable freetds debug it shows that the correct number of rows is returned:
token.c:2370: rows_affected = 10000
But we still get the error in MyDBR.
BUT if I take the URL that is shown in the error and paste it in the browser the data is retrieved correctly in json format but it's slow. When we run the reports local on the MyDBR using ASE the queries takes about 1 second to execute and then the time to render the 60000 rows.