When I cancel a query in OBIEE 126.96.36.199, should it be able to cancel the query in the Microsoft SQL server? I am using ODBC 3.5 connection on the model. This is the first time we've connected to a Microsoft SQL database and I'm finding that when I cancel the query in OBIEE, it is still running on the database. If I go into administration and cancel the query, it says it is still running. I checked with the DBAS and they confirm that the query really is still running.
I found a similar article that suggested this was fixed in 188.8.131.52. but we are on 184.108.40.206.
Thanks in advance for any ideas.