Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accessing QV Server using QV OCX

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?

5 Replies
Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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.

erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

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)