Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jacqueshol
Creator
Creator

Problems connecting to ODBC

Hi All,

I, as a novice, would appreciate some assistance.  I have a small Microsoft Access database that I want to connect to in QlikView 11.2 SR8.

However whenever I create a new QlikView file, select Edit Script, ODBC as my Database and click Connect, I get the following error:Capture.jpg

I have tried connecting to the Access database from another machine and got the same error.  Obviously some setup is missing, but I can figure out a solution.  I thought perhaps my Microsoft Access is installed incorrectly, but I am able to open the Access database and edit as needed.  Just can't connect to the database in QlikView.  Any help would be greatly appreciated.

Thanks,

Jacques

13 Replies
beck_bakytbek
Master
Master

Hi Jacques,

if you need the same way of proceeding for MDB.Format.

just let me know

beck

jacqueshol
Creator
Creator
Author

Hi Beck,

I would appreciate that.  It would be nice to be able to connect to the MDB format too.

Thank you for assisting. Much appreciated!

Take care,

Jacques

beck_bakytbek
Master
Master

Hi Jacques:

here is a way of proceeding in case of : MDB.Format

step1: Select "OLE DB" in the Database tab

step2: Check "force 32 bit"

step3: Click "Connect"

step4: in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"

step5: Click "Next"

step6: You will be directed to "Connection" tab

step7: Select the Database in 2002 Format(.mdb)

step8: Go to "Advanced" tab, uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection" tab and click "Test Connection"

step10: You will have message: like "Test Connection succeeded"

step11: Click "Ok"

beck

jacqueshol
Creator
Creator
Author

Hi Beck,

Thanks a mill, once again!  Truly appreciate the wonderful help I got.

Take care,

Jacques