topic Accessing QV Server using QV OCX in QlikView

Accessing QV Server using QV OCX

Thu, 22 Mar 2012 19:26:21 GMT

Using QV Desktop I can access files on a QVServer.

I would like to replicate that capability in an windows desktop app that I have that includes the QV OCX.

Is it possible to use the OCX to access qvw files stored on a QlikView Server?

Accessing QV Server using QV OCX

Thu, 22 Mar 2012 22:15:35 GMT

Depending on your security policies, geopgraphic location to your server, - if you have a UNC path (// or mapped drive) to your QV Server, you can enter it in the DocName Property.

In Design Mode of i.e. Excel (I assume you have the OCX registered) when you right click the object (after accessing it from your Insert -> More Controls button)

-> Qlik OCX Control Object -> Properties -> DocName

Enter the path i.e. Q:\MyFolder\MyQlik.qvw

For some reason I cannot attach images (to give you a screen print of what I mean).

Hope this helps.

Accessing QV Server using QV OCX

Tue, 01 May 2012 17:55:28 GMT

My users do not have mapped drive capabilities to the QVServer directories, e.g. QVServer in the cloud.

I have found that I use qvp protocol to specify the file in the OCX OpenDocument (or OpenDocumentEx) API to get the files from the QVServer into my OCX.

Re: Accessing QV Server using QV OCX

Wed, 07 Nov 2012 22:54:19 GMT

I have found that I can use an OCX embedded in a app to access a qvw on an accesspoint in the following case:

1) User has an account with the same name/pswd on the their personal machine and on the QVServer host

2) Embed the OCX in a application.

3) Application calls OCX api OpenDocumentEx and passes the name of the document as qvp://10.5.15.15/foo.qvw or qvp://TargetServer/dir1/dir2/foo.qvw

where the name of the server host is either an ip or server name and the file within the server is specied as per the accesspoint data folder containment.

Re: Accessing QV Server using QV OCX

erichshiino — Thu, 08 Nov 2012 17:02:31 GMT

Hi, Daniel

I'm trying to use OCX on MS office applications.

I did similar tests.

In your case, what happens when condition 1) is not satisfied? Do you get a blank object, an error message?

If you lose server connection, what happens to the object? Does it keep the last content or you get an error message?

I started a similar discussion here: http://community.qlik.com/message/278810#278810

Regards,

Erich

Re: Accessing QV Server using QV OCX

Thu, 08 Nov 2012 17:08:48 GMT

If I don’t have an account, I get a dialog QlikOcx: Failed to open document. You don’t have access to this document.

Daniel Lipkie, Senior Software Development Engineer

Terra Technology | Accurate. Current. Consistent.

206 204 9514

425 241 5682 (cell)