Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello Onno,
I appreciate your time. I have attached the error I am getting could you please have a look.
Thanks!
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`;
The (missing) comma should not be the problem as "details" is a "detail".
I think you are right about the others two points.
correct,Onno, I thought "Details" was the keyword.
Thank you guys for your time and I sincerely appreciate it. Still getting a syntax error:( after all your corrections
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];