topic Re: Error in tutorial - Loading a file via OLE DB in QlikView

Error in tutorial - Loading a file via OLE DB

Tue, 18 Feb 2014 23:43:55 GMT

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.

Re: Error in tutorial - Loading a file via OLE DB

arulsettu — Wed, 19 Feb 2014 05:49:47 GMT

enable force 32 while you connect database...

Re: Error in tutorial - Loading a file via OLE DB

Wed, 19 Feb 2014 05:53:02 GMT

Hi John,

Check this link

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion

Regards

Mahesh T

Re: Error in tutorial - Loading a file via OLE DB

Wed, 19 Feb 2014 20:31:27 GMT

my bad - link for training materials is here - http://www.qlik.com/~/media/Files/training/tutorials-qv11/English.ashx

Re: Error in tutorial - Loading a file via OLE DB

Wed, 19 Feb 2014 20:36:40 GMT

Yes, this works. Thanks. The error message is not helpful.

Re: Error in tutorial - Loading a file via OLE DB

Wed, 19 Feb 2014 20:37:37 GMT

Thanks for the link.

Re: Error in tutorial - Loading a file via OLE DB

arulsettu — Thu, 20 Feb 2014 06:21:48 GMT

if you are clear with your doubt please close the thread. it might be helpful for others..

Re: Error in tutorial - Loading a file via OLE DB

Thu, 20 Feb 2014 08:11:36 GMT

Thanks. Yes, I will. I will search for that button amid the useless clutter of other buttons. This forum should be sent to stackoverflow instead of jive. Its a shame that a visualization tool chose such a crappy/clunky forum.

Anyway, I put that as an idea. Please post it if you like.

Re: Error in tutorial - Loading a file via OLE DB

Mon, 08 Dec 2014 14:38:22 GMT

I got the same issue and Force 32 bit doesn't help. Any idea? Thanks!

Re: Error in tutorial - Loading a file via OLE DB

Tue, 17 Feb 2015 21:45:34 GMT

hi i have the same problem but "the force 32 bit" solution doesnt works for me instead i have this error

"can't open a database created whit an older version of the application"

any idea?

thanks for your time

The Red Elf !!

Re: Error in tutorial - Loading a file via OLE DB

johannesm2 — Tue, 24 Feb 2015 15:30:21 GMT

If the "Force 32 bit" solution doesn't work for you, try using the "Tutorial ODBC" Machine Data Source instead of the "MS Access Database," shown below. I was able to get around the errors and continue the tutorial using this solution.

Thank you!

Johannes Myers

Re: Error in tutorial - Loading a file via OLE DB

Tue, 24 Feb 2015 22:34:51 GMT

THANKS !!

but i do the next thing

download old version of MS OFICCE ACCESS ( i have 2013 so i have to donwload and install 2010)

open the file Salesman.mdb whit the ACCESS 2010 then ask me to change the version of the file

i acept and the file go like this Salesman.accdb

and now the qlikview acepted this version and load it

sorry if i miss something in the translation !!

thanks again

Re: Error in tutorial - Loading a file via OLE DB

Tue, 14 Jun 2016 23:09:19 GMT

I'm getting a similar issue and the "Force 32 Bit" option isn't working for me either. I get an error that says: Unable to load odbcji32.dll. Any ideas on what might be causing this error?

I looked for the "Tutorial ODBC" that Johannes Myers suggested, but that option doesn't appear for me.

Any support that you could provide would be greatly appreciated!

Thanks

Re: Error in tutorial - Loading a file via OLE DB

Tue, 02 Aug 2016 14:16:11 GMT

It was indeed very helpful! Thanks