Direct Discovery with MS SQL Views - Direct query failed

Anonymous — Thu, 23 Apr 2015 10:25:16 GMT

Hello,

I have some problems with Direct Discovery. We use QlikVew 11.2 SR10 with MS SQL 2008 R2 and publish the Apps on AccessPoint.

Direct Discovery works only if it access to sql tables directly or views with one table. If I use joins in views I get an error "direct query failed".

In addition is Direct Discovery very selektiv with sql view formats. Not all formats will be accepted.

With Views, which contain another views, doesn't work direct discovery too. Always error "direct query failed".

Has anyone expirienced this?

P.S. In Desktop works all, the problem is with AccessPoint only.

Re: Direct Discovery with MS SQL Views - Direct query failed

Anonymous — Tue, 28 Apr 2015 11:09:55 GMT

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

topic Re: Direct Discovery with MS SQL Views - Direct query failed in QlikView

Direct Discovery with MS SQL Views - Direct query failed

Re: Direct Discovery with MS SQL Views - Direct query failed