Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
stabben23
Honored Contributor

Task fail in Publisher, Access data

Hi,

I have a problem when run a task in publisher, the application works when I reload manually on server.

QVS and QVB is running on different machines. The provider is installed on both (not necessary i think).

From Logfile:

OLEDB CONNECT32*Provider*Password*Password*

04.11.2013 21:38:05:       Error: ErrorSource: Microsoft Office Access Database Engine, ErrorMsg: Unrecognized database format '\\fileserver\Qlikview\QVData\Private\Production\Access\Data.ACCDB'.

/Stabben

Tags (1)
3 Replies
Employee
Employee

Re: Task fail in Publisher, Access data

Hi,

Not sure if this is your issue are not, but I would make sure that the service account that is running the QlikView services has the same rights to the Database as the user that is running it manually.

Bill

stabben23
Honored Contributor

Re: Task fail in Publisher, Access data

Hi Bill,

It all the same user that is running the service account as do it manually.

The only different user is the user in provider, here it is a account Admin. This user has no password.

CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=\\fileserver\Qlikview\QVData\Private\Production\Access\Data.accdb

Employee
Employee

Re: Task fail in Publisher, Access data

OK, is the ODBC setup as a user DSN or a System DSN? I would try it as a system DSN and see that would work.

Bill

Community Browser