QVSAdminDataProvider.dll

[hoodhill]

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.

[#2]

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

[Ronnie_Taborn · Accepted solution]

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;";

[#4]

Solution 2 worked for me - thanks Ronnie!

[Ronnie_Taborn]

You are welcome and have a great day!