Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding Direct Query

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

7 Replies
oknotsen
Master III
Master III

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

May you live in interesting times!
Not applicable
Author

Hello Onno,

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

Thanks!

stabben23
Partner - Master
Partner - Master

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`;

oknotsen
Master III
Master III

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

I think you are right about the others two points.

May you live in interesting times!
stabben23
Partner - Master
Partner - Master

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

Not applicable
Author

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

stabben23
Partner - Master
Partner - Master

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];