excel file driver not reloading from QMC?

[#1]

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.

[Colin-Albert]

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.

[#3]

tried it not working

[Colin-Albert]

What's not working?

[#5]

please see attached it is failing to reload at that point

[Colin-Albert]

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

[#7]

yes. but it is failing when running through QMC

[Colin-Albert]

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

Change Macro security to allow System Access