After several days of working across SQL Server and Oracle connections with no issues, today I started encountering the following error whenever I connect to a SQL Server database:
“An expression of non-boolean type specified in a context where a condition is expected, near ‘AND’.”
It seems that the connection itself is successfully made, as I am able to run queries, but I am not able to see any information in the Object Explorer (instead I get a red X icon with “SQL Server Database Error” next to it). If I use SQL Server Mgmt Studio, I am able to connect, browse objects and run queries with no issues. Also, I am still able to connect to Oracle in Toad and use the Object Explorer with no issues.
I did not modify any connection settings between my last successful SQL Server connection and the start of the error. I have also tried connecting to several different SQL Server servers / instances and see the same error each time. One change I did make today (prior to the start of the error) was to create / apply an Object Explorer filter while working in one of my Oracle connections. I’ve noticed since then that it seems to default to the “IN” search condition vs. "Glob (* wildcard), and suspect perhaps something in that area may be at the root of my issue.
For reference, I am using Toad for Data Analysts v2.7.
Has anyone else encountered (and resolved) an error like this? Please advise, thanks!!