I downloaded the free qlikview tutorial (with necessary files) here - http://www.qlik.com/us/services/training/find-your-training/
I am trying to do the task on pg 168/233 - Loading a file via OLE DB. In this task, I have to load a MS Access file into qlikview,
i.e a .MDB file. I got an error in the step 7 - Operation cannot be executed because an error occurred during connection to the
driver. How do I fix this problem ?
The steps are given below -
1 Open the Edit Script dialog.
2 Place the cursor at the end of the script.
3 In the Database drop-down select OLE DB and click the Connect button to
establish a connection with the data source.
4 The Data Link Properties dialog opens. Make sure that the OLE DB Pro-
vider for ODBC Drivers is selected, then click Next >> to get to the Connec-
tion page.
5 Since you are working with a generic data source not yet defined, select the
option Use connection string , then click the Build button. The Select Data
Source dialog opens.
6 Go to the tab Machine Data Source .
7 Select MS Access Database, then click OK .
8 From the Login dialog that opens, click the Database... button. The Select
Database dialog opens.
9 Browse for the file Salesman.mdb in the Tutorial\Creating a Document\Data
Sources directory. Once you find the correct location, the salesman file
should be the only one available in the left list. Select it, then click OK to
close the dialog.
10 Click OK to close the remaining dialogs.
Your script now contains a connect statement, connecting you to the selected data
source. The statement looks similar to this................................
I am attaching the .mdb file and tutorial for reference.
