Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Loading from Access(.mdb) in a mapdrive fails in the QMC

Hi everyone,

Each time I schedule a reload on the QMC it fails. The .mdb file type sits on another box but mapped on the QV server which I'm able to connect through OLE DB. Also I have assigned all rights to the service account but for some unknown reasons it does run in the QMC but does manually,

Please help! thanks.

1 Solution

Accepted Solutions
Highlighted

Re: Loading from Access(.mdb) in a mapdrive fails in the QMC

You need to reference the mdb file using a UNC path such as \\servername\folder\database.mdb instead of a mapped drive. Services cannot access the mapped drive letters.

Your server reload  is run by the QlikView Distribution Service which cannot see the mapped drive letter.

View solution in original post

2 Replies
Highlighted

Re: Loading from Access(.mdb) in a mapdrive fails in the QMC

You need to reference the mdb file using a UNC path such as \\servername\folder\database.mdb instead of a mapped drive. Services cannot access the mapped drive letters.

Your server reload  is run by the QlikView Distribution Service which cannot see the mapped drive letter.

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Loading from Access(.mdb) in a mapdrive fails in the QMC

I figured out the solution by using the UNC path.