topic Re: QVSAdminDataProvider.dll in QlikView

QVSAdminDataProvider.dll

hoodhill — Fri, 13 Jun 2014 15:32:30 GMT

I've created a qvw file with the following script:

CONNECT TO "Provider=QvsAdminDataProvider.dll;host=localhost;XUserId=RJfIDRD;XPassword=DJUBNCD;";
LOAD AttributeName,
AttributeValue;
SQL SELECT *
FROM DocAttributes;

when the qvw is reloaded the log file shows the following....

CUSTOM CONNECT*Provider*QvsAdminDataProvider.dll*XUserId*XPassword*

13/06/2014 16:19:03: 0014 LOAD AttributeName,

13/06/2014 16:19:03: 0015 AttributeValue

13/06/2014 16:19:03: 0016 SQL SELECT *

13/06/2014 16:19:03: 0017 FROM DocAttributes

13/06/2014 16:19:03: 2 fields found: AttributeName, AttributeValue, 0 lines fetched

13/06/2014 16:19:03: Execution finished.

From this I assume that it's worked ok.

Now, I run the same qvw, this time from the Management Console (where I've tried to define Attributes/Values via the Source Documents>Document Information option for the task). The following error is displayed in the log.

CUSTOM CONNECT*Provider*QvsAdminDataProvider.dll*XUserId*XPassword*

13/06/2014 15:54:12: Error: Invalid custom connector QvsAdminDataProvider.dll

13/06/2014 15:54:12: Used QVConnect: C:\Program Files\QlikView\Distribution Service\QvConnect64.EXE

13/06/2014 15:54:12: General Script Error

13/06/2014 15:54:12: Execution Failed

13/06/2014 15:54:12: Execution finished.

Questions:

1. Is it just a set-up issue somewhere and if so, what has been missed?

2. If not a set-up issue, how can I retrieve within the qvw the Attributes/Values from the task defined within the Management Console or do I require something like publisher to do all this.

Many thanks.

Re: QVSAdminDataProvider.dll

Mon, 30 Jun 2014 17:40:09 GMT

Tim - I wonder if the service account that runs your QV services does not have sufficient permissions? (That would be pretty unusual though.)

I'm currently trying to do something similar with this data connector, I'll let you know if I experience the same.

Bill

Re: QVSAdminDataProvider.dll

Ronnie_Taborn — Mon, 30 Jun 2014 17:46:15 GMT

Solution 1:
Copy the file: QvsAdminDataProvider.dll from C:\Program Files\QlikView to folder C:\Program Files\QlikView\Distribution Service

Solution 2:
1. Open the document affected with QlikView desktop and enter script editor.

2. Locate the connection string:
"CUSTOM CONNECT TO "Provider=QvsAdminDataProvider.dll;host=localhost;XUserId=bPOcEBC;XPassword=ZQLSGYC;";"

3. Edit string so it includes full filepath to QvsAdminDataProvider.dll.
Example: CUSTOM CONNECT TO "Provider=C:\Program Files\QlikView\QvsAdminDataProvider.dll;host=localhost;XUserId=bPOcEBC;XPassword=ZQLSGYC;";

Re: QVSAdminDataProvider.dll

Mon, 30 Jun 2014 18:19:04 GMT

Solution 2 worked for me - thanks Ronnie!

Re: QVSAdminDataProvider.dll

Ronnie_Taborn — Mon, 30 Jun 2014 18:22:13 GMT

You are welcome and have a great day!