topic MAPI issue in QlikView

MAPI issue

amien — Thu, 24 Dec 2009 20:04:57 GMT

i have a access database. In that database i'v a link to an outlook mail folder. when i click the link in access i see all the column and data.

Now .. i have added an ODBC connection with qlikview to that outlook link in access. i see the table.. even the preview of the data in outlook.

but on reload, i get this error:

SQL Error:[Microsoft][ODBC Microsoft Access Driver] There are no MAPI clients installed on this machine. Install a MAPI client (like Outlook) on this machine.
SQL Scriptline:
SQL State:S1000
SQL SELECT *
FROM TABLE

data is on exchange server

MAPI issue

Thu, 24 Dec 2009 21:12:47 GMT

It seems you need to install a MAPI client on the machine you are reloading the data from.

You should install Outlook ( as far as the error message is asking...)

Another way to get rid of that link is to use a vbs script to export the data you need, then attack the export from QV ?

Sébastien

MAPI issue

amien — Fri, 25 Dec 2009 00:15:05 GMT

thanks for your reply

outlook is installed. mind also that i see data in preview .. reloading doesnt work. Access file is on the same workstation as qlikview application.

instead of linking the outlook folders in access, i could also import the data into a access table.. but then i have to reload both access and qlikview. was hoping to do it just on the qlikview side.

anyone else?

MAPI issue

amien — Mon, 28 Dec 2009 03:59:34 GMT

i tested the same qlikview on my laptop instead of my workstation .. and i dont get an error there..

on both sides ole db 4.0 are the same version .. and both have outlook 2007 running

CONNECT TO [Provider=Microsoft.Jet.OLEDB.

4.0;User ID=Admin;Data Source=file.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;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];