topic Re: Regarding Direct Query in QlikView

Regarding Direct Query

Wed, 25 Nov 2020 16:16:04 GMT

Hello Friends,

I appreciate your time. My below syntax for direct query is giving a syntax error, could you kindly have a look and let me know.

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Documentation\Database2.accdb];

DirectDiscovery:

DIRECT QUERY

dimension

ID,

Product,

Customer

detail

Details

measure

Sales;

SQL SELECT *

FROM `Direct_D`;

Thank you!

Regards,

Kiruthiga

Re: Regarding Direct Query

oknotsen — Mon, 13 Mar 2017 08:26:13 GMT

Could you tell us the exact error you are getting?

Without knowing the error, my guess would be that you are missing the required parameters.

Data sources supported in Direct Discovery ‒ Qlik Sense

Re: Regarding Direct Query

Mon, 13 Mar 2017 11:58:45 GMT

Hello Onno,

I appreciate your time. I have attached the error I am getting could you please have a look.

Thanks!

Re: Regarding Direct Query

stabben23 — Mon, 13 Mar 2017 12:03:58 GMT

Hi,

could it be that you are missing a ',' and a ';' too much and no SQL select

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Documentation\Database2.accdb];

DirectDiscovery:

DIRECT QUERY

dimension

ID,

Product,

Customer, //Here

detail

Details

measure

Sales; //No ';' here

SQL SELECT * //Remove this

FROM `Direct_D`;

Re: Regarding Direct Query

oknotsen — Mon, 13 Mar 2017 13:24:08 GMT

The (missing) comma should not be the problem as "details" is a "detail".

I think you are right about the others two points.

Re: Regarding Direct Query

stabben23 — Mon, 13 Mar 2017 13:56:37 GMT

correct,Onno, I thought "Details" was the keyword.

Re: Regarding Direct Query

Mon, 13 Mar 2017 18:58:21 GMT

Thank you guys for your time and I sincerely appreciate it. Still getting a syntax error:( after all your corrections

Re: Regarding Direct Query

stabben23 — Tue, 14 Mar 2017 06:46:12 GMT

Hi,

if this doesent work, show us the modified script again.

SET DirectIdentifierQuoteChar='``'; //add this line

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Documentation\Database2.accdb];

DirectDiscovery:

DIRECT QUERY

dimension

ID,

Product,

Customer

detail

Details

measure

Sales

FROM `Direct_D`;

You maybe have to change Your Connection, this is what a have used:

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Z:\Spec.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];