topic Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help ! in QlikView

Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

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

Hi All ,

I am not able to establish connection to .accdb file (on network path) using Qlikview 12 .

Path of Network Drive : \\xxxxxx01\xxxxdata\BI\Sales\Test\01_Global\CFO\Data

File Name : Action.accdb

I tried OLEDB with Force 32 Bit with below error .

I tried OLEDB without Force 32 Bit and got below options :

I don't see Microsoft Jet 4.0 OLE DB Provider option which i had used long back for connecting .

with ODBC

Please suggest

Thanks & Regards

Shekar

Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

syed_muzammil — Thu, 07 Jun 2018 11:28:17 GMT

Hi,

You can install the Microsoft Office Jet OLEDB Drivers. It usually comes with the Microsoft Office setup. Then try connecting using the driver.

Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

Miguel_Angel_Baeyens — Thu, 07 Jun 2018 11:54:57 GMT

This is the most recent equivalent to Jet drivers for *.ACCDB files (Office 2016):

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Once installed, a "Microsoft Access Driver" option will appear in the ODBC Data Sources which will allow you to create a new DSN for your file. As long as the account used for QlikView has access to the network location and the file, it will be able to connect, read and load.

Also, at least one of the messages you screenshot mentions that you are using the wrong architecture, which means you are creating a 64 bit DSN for a 32 bit connection or the other way around. I suggest you to check which ODBCAD32.EXE you are using and make sure that is the one matching your drivers.

Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

shekhar_analyti — Thu, 07 Jun 2018 12:56:26 GMT

Hi Syed ,

I have Microsoft office 2013 already installed in Machine

Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

shekhar_analyti — Thu, 07 Jun 2018 14:26:05 GMT

Hi Miguel ,

I have MS OFFICE 2013 already iinstalled in my machine , do i need to seperately install above component

Re: Not able to establish connection to .accdb (on network path) using Qlikview 12 . Please help !

Miguel_Angel_Baeyens — Thu, 07 Jun 2018 15:26:18 GMT

Yes, you need to install it. The link above is for the Office 2016 version, which is compatible. But check in your control panel in case you already have the version for Office 2013, download it from Microsoft website or ask IT in case they have this component.