topic Re: QVD Access Script Reload Fail in QlikView

QVD Access Script Reload Fail

Mon, 26 Jan 2026 18:19:17 GMT

Running QVS 11.20 x64 on a Windows Server 2008 R2 x64

I have a file that references an access database in another location as well as a SQL database. I created a task to reload the data in the file, the reload fails. If I comment out the section that references the Access file then the reload completes. This same script runs fine on a local machine leasing a license without any commenting.

Does this have anything to do with no Microsoft Office being installed on the server machine? The connection to the SQL server is fine as well.

Thanks.

Re: QVD Access Script Reload Fail

Peter_Cammaert — Thu, 14 Jan 2016 12:33:21 GMT

Yes, of course. Every Microsoft Office installation comes with OLEDB(ODBC) drivers and a Jet engine to access various MS Office file formats with a query engine.

Fortunately, you don't have to install an MS Office license on your server to get your reload up and running. You can install the drivers as a separate package. See Re: Connect to Ms Access files? for a link to some older packages. Search the Microsoft Downloads site for newer drivers.

But of course, it could be something entirely different. What is the exact error message in the Document Log? If you can't find a Document Log, enable Settings->Document Properties->General->Generate Log File, save your QVW and rerun your server reload task.

Best,

Peter

Re: QVD Access Script Reload Fail

Thu, 14 Jan 2016 14:18:58 GMT

Thanks for responding. I have installed the ODBC drivers for Office 2010 Suite from Microsoft but still get the following error at the end of my log:

0189 OLEDB CONNECT64*Provider*Password*Password*

Error: ErrorSource: Microsoft Access Database Engine, ErrorMsg: Could not find installable ISAM.

General Script Error

Execution Failed

Execution finished.

Re: QVD Access Script Reload Fail

Peter_Cammaert — Fri, 15 Jan 2016 09:35:00 GMT

There may be a problem with your driver setup. Check this link for a possible solution:

https://support.microsoft.com/en-us/kb/209805

Best,

Peter

Re: QVD Access Script Reload Fail

Mon, 18 Jan 2016 14:39:10 GMT

Yes, turns out it was a driver call issue. Thanks!