Simple Query Throwing Error but seems Connection Successful

Hi There,

I have created a System DSN and test appearing to be successful.
Next, I created a Linked Server in SQL Server… Again Test Connection Successful.
Then I am trying to write a simple query (SELECT TABLE_NAME FROM [SERVER_DAL].[DREMIO].INFORMATION_SCHEMA.TABLES) to test - its running 4 - 5mins and then returning error message (and no result).

What possibly going wrong here please? Any guidance would be really appreciated.


@amukjee I see you have written SQL Server specific SQL, example using , can you simply try the below SQL?