Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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

Hello Onno,

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

Thanks!

stabben23
Master
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
Master
Master

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

Not applicable

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

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