topic Re: Problems connecting to ODBC in QlikView

Problems connecting to ODBC

jacqueshol — Wed, 25 Nov 2020 16:16:04 GMT

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:

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

Re: Problems connecting to ODBC

qlikviewwizard — Fri, 29 Jul 2016 03:32:43 GMT

Hi ,

Did you configure the database at Control Panel\All Control Panel Items\Administrative Tools.

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 08:52:21 GMT

Hi Wiz,

Thank you kindly for the response. I was initially quite excited when I saw your response and immediately tried it out. Unfortunately, when I try and add the MS Access driver (*.mdb, *.accdb), I get exactly the same error. Any other ideas?

For the sake of completeness, I checked the "User DSN" and "Drivers" tabs and the MS Access Drivers appear there.

Re: Problems connecting to ODBC

rubenmarin — Fri, 29 Jul 2016 09:12:23 GMT

Hi Jacques, if OBDC administrator returns the same error it seems a MS office issue (it can be only the driver installation) maybe a fix or reinstall can fix the issue.

Re: Problems connecting to ODBC

beck_bakytbek — Fri, 29 Jul 2016 09:14:27 GMT

Hi Jacques,

what Kind of Format do you use? accdb or MdB?

beck

Re: Problems connecting to ODBC

beck_bakytbek — Fri, 29 Jul 2016 09:21:55 GMT

Jacques,

if you're using accdb. Format, then you can make the following steps:

step 1: SELECT "OLE DB " in the Database tab

step2: Check "force 32 Bit"

step3: Click "Connect"

step4: in the "Data Link Properties ". Select "Microsoft Office 12.0 Access Database Engine OLEDB Provider"

step5: Click "Next"

step6: You will be directed to "Connection Tab"

step7: Copy and paste the complete/full path of the Access Database ("E\.....\yourDatabase.accdb")

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

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

step10: then you will have a message : "Test Connection succeeded"

step11: Click "OK"

i hope that helps

beck

Re: Problems connecting to ODBC

Peter_Cammaert — Fri, 29 Jul 2016 09:44:12 GMT

Is your Windows account member of the local Administrators group on your machine?

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 09:49:49 GMT

Beck Beck, you are amazing! It worked! Thank you so much.

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 09:50:47 GMT

Hey Peter, thank you for your response. I tried Beck Beck's solution and it worked! Very happy indeed! Thank you kindly though for assisting

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 09:51:54 GMT

Thanks for the response, Ruben! Problem resolved with Beck Beck's assistance.

Re: Problems connecting to ODBC

beck_bakytbek — Fri, 29 Jul 2016 09:54:57 GMT

Hi Jacques,

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

just let me know

beck

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 09:57:19 GMT

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

Re: Problems connecting to ODBC

beck_bakytbek — Fri, 29 Jul 2016 11:02:07 GMT

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

Re: Problems connecting to ODBC

jacqueshol — Fri, 29 Jul 2016 12:43:58 GMT

Hi Beck,

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

Take care,

Jacques