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]

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.

[#3]

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

[awhitfield]

Hi Amelia,

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

HTH Andy

[Colin-Albert]

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.

[#6]

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

[Colin-Albert]

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?

[awhitfield]

Hi again,

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

Andy

[#9]

on the server

[#10]

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