Posted on 2009-12-24
Last Modified: 2012-05-08
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

note: i use Qlikview to access outlook using odbc and mails are on exchange server
Question by:Amien90
    LVL 30

    Expert Comment

    From its name "Messaging Application Programming Interface (MAPI)", I think it requires programs for ODBC to communicate.
    Have you outlook installed and working on the current machine?

    Author Comment

    thanks for your reply..

    yes .. i have outlook 2007 installed on the current machine..

    Strange thinks .. i'v testethe 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];
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    <<but on reload, i get this error:>>
    What do you mean by "reload"?
    By the way, I think the error message is mis-leading in that this is not a connection problem, but one of security and/or user accounts.  I think what is happening is that under the user account that Qlikview is using when you get the error currently has no MAPI profile, so you get the error message.

    Author Comment

    with reload i mean .. giving qlikview the command to reload the data.

    security issue .. but why does it work on my laptop .. and not on my desktop? laptop from home .. desktop @ work
    LVL 56

    Accepted Solution

    <<security issue .. but why does it work on my laptop .. and not on my desktop? laptop from home .. desktop @ work>>
    With tthe laptop, are you using a VPN to connect to the network? vs at work, you have a different style connection?
    or in one case is qlikview used in a desktop mode vs being used as a service (something in the system tray) on the other?
    Again, I think the error message is mis-leading and just indicating a failure, but not for the reason it says.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now