Simple Query Throwing Error but seems Connection Successful

1

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.

image
image623×900 117 KB

image

image
image1220×203 16 KB

2

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

SELECT * FROM INFORMATION_SCHEMA."TABLES"