MSSQL Views Not Showing

Hello,

For me I am using sqlsrv and still not working even I got 500 error could not log to my tables in Tools JX component when chose any one listed I got that 500 error . but I notes that you where using information_schema which is only in mysql is it ?

Looking forward for the solution from you tomaz .
Thanks

semicolon ; was missing .

Works like like a charm .

Thanks a lot tomaz .

Update :

As I said early it is working fine but there are some minor issues if you are able to solve it , it will be perfect extension .

when I click Next page to see the next page of the result it's showing blank page also the search result not working .

Thanks in advance tomaz.

Hi
I'm getting a similar problem, i.e. all was working fine but now only for tables, I can see views but when I use any I get: 1045 Access denied for user 'me'@'localhost' (using password: YES) SQL=SELECT COUNT(*) FROM `v_callback`

I've tried the above fix, but that didn't work.


EDIT post: -
*** Found problem, all at my end. Great extension!! ***

Many Thanks

Hi! I just wanted to check in and let you know that the fix you posted worked perfectly. I am now able to see MSSQL Views in the list of tables to select from.

I did, however, come across one more issue but I am fairly certain the issue is just due to a syntax discrepancy between MSSQL and MySQL (limit vs top). When I enable Advanced Filters on a MSSQL View the Textbox setting works great but the List setting generates the following error-

0 - Incorrect syntax near 'LIMIT'.SQL=SELECT DISTINCT MISJobNumber FROM view_SEGShippingReport ORDER BY MISJobNumber ASC LIMIT 0, 100