Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading data from a query in a Microsoft Access database. I am able to connect to the query and reload the data when I run it from the desktop client. However, when I try to schedule a reload task in the Management Console I receive an error saying "The source document was not loaded successfully". I am able to successfully reload through the Management Console when I only try to load an inline table, so I think it has to do with the connection to the Microsoft Access database.
Any thoughts?
I manually replaced the part of the connection string in the script that had the mapped drive with the UNC path and it worked:
ODBC CONNECT TO [Access Database;DBQ=Q:\Info\DB\Metrics.accdb];
Replaced with:
ODBC CONNECT TO [Access Database;DBQ=\\tfs1\groups\Info\DB\Metrics.accdb];
Thanks!
Is the database password protected?
What is the path to the access database file?
If it is a mapped drive, then the QlikView service may not be able to access the path.
Try using a UNC path to the file in the load script.
Does the QV Service account have permission to open the database?
The service account under which the services are running should have access to the MS Access database
I manually replaced the part of the connection string in the script that had the mapped drive with the UNC path and it worked:
ODBC CONNECT TO [Access Database;DBQ=Q:\Info\DB\Metrics.accdb];
Replaced with:
ODBC CONNECT TO [Access Database;DBQ=\\tfs1\groups\Info\DB\Metrics.accdb];
Thanks!