topic Re: excel file driver not reloading from QMC? in QlikView

excel file driver not reloading from QMC?

Thu, 30 Jul 2015 13:05:46 GMT

HI,

I have 12 excel sheets in excel work book. to load all these sheets. I did script. every time it is failing to reload in QMC but when I run in desktop it is working fine. below us the error showing

Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I have excel files loaded successfully in some of the qvws from QMC. only this file is failing. I think this is driver problem? the othser excel files have only one or two sheets. so, I mapped them directly. but only this file have script to lad all 12 sheets at a time and below is the driver path I used

ODBC CONNECT32 TO [Excel Files;DBQ=C:\Qlikview\folder\Portdata.xlsx];

can anyone suggest me how to set this.

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 13:08:55 GMT

The path C:\Qlikview\folder\Portdata.xlsx is referring to files on your PC.

You need to move the files to the server and then reference the server path to the files.

You will also need to give the QDS service account permissions to the files & folder.

Check the document logs on the server and you will see the error.

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 13:12:27 GMT

Thanks. the files are in server only. which document logs you mean?

Re: excel file driver not reloading from QMC?

awhitfield — Thu, 30 Jul 2015 13:14:42 GMT

Hi Amelia,

make sure that the QV Service user has sufficient NT Permissions to open the FILE in question.

HTH Andy

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 13:16:03 GMT

Tick Generate Logfile on the Document Properties General sheet, save then and reload the document.

You will get a log file in the same folder as the QVW file.

Look at the end of the log to see if the reload was successful or to see any errors.

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 13:18:33 GMT

that is the error showing which I posted in my first post

Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 13:35:46 GMT

Does the QDS service account have permissions to the files and folder?

Also does the QDS account have access to any ODBC DSN that the script uses?

Re: excel file driver not reloading from QMC?

awhitfield — Thu, 30 Jul 2015 13:41:53 GMT

Hi again,

when you execute the reload from QV desktop, is this on the server OR elsewhere?

Andy

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 14:03:50 GMT

on the server

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 14:04:38 GMT

how to know whether these have access to QDS? where I can see this?

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 14:09:50 GMT

Right-click on the file, Properties, Security, Advanced, Effective Permissions

Enter the account that runs the QDS service and you will see if the account has permissions.

Alternatively, logon to the server using the service login and if there is a copy of QV Desktop on the server, run the reload on the server.

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 15:16:37 GMT

tried it not working

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 15:21:28 GMT

What's not working?

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 15:33:11 GMT

please see attached it is failing to reload at that point

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 15:42:03 GMT

Does the script run OK if you click "Give System Access"

Re: excel file driver not reloading from QMC?

Thu, 30 Jul 2015 15:46:18 GMT

yes. but it is failing when running through QMC

Re: excel file driver not reloading from QMC?

Colin-Albert — Thu, 30 Jul 2015 15:50:15 GMT

Look at the correct answer to this post and the Settings.ini changes.

Change Macro security to allow System Access