Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dimitri_obrant
Contributor

Direct Discovery with MS SQL Views - Direct query failed

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.

1 Solution

Accepted Solutions
dimitri_obrant
Contributor

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

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

1 Reply
dimitri_obrant
Contributor

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

I found the solution:

SET DirectUnicodeStrings=TRUE;

It works fine now.

Community Browser