QlikView Direct Discovery

[#1]

Hello All.

I am using QlikView 11.2 SR 15. I am trying to set up a Direct Discovery connection to an OLEDB SQL server using the following syntax.

DIRECT SELECT Field1,
Field2
FROM Database."Owner"."Database Tables";

When I run the script, I receive a "Line is not valid." error. The script does not seem to like the quotation marks, but that is what the connection set up provides.

Thank you in advance.

Tom

[Anil_Babu_Samineni]

From help it is showing like below link. Check if it helps you

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement...

[anushree1]

Hi Tom,

I had faced the same issue earlier and got it resolved by adding the below variable before loading the data.Request you to try the same:

SET DirectCacheSeconds= 15;

SET DirectStringQuoteChar=’”’;

SET DirectIdentifierQuoteChar=' ';

SET DirectConnectionMax= 4;

SET DirectTableBoxListThreshold= 100000;

SET DirectDistinctSupport=true;

SET DirectIdentifierQuoteStyle=’ANSI’;