First time here? Check out the FAQ!

How to read a Hyperion bqy fille in Visual Basic 2012?

0 votes
asked by
edited by

I am converting a Visual Basic 6.0 application to VB.Net 2012. It reads .bqy files using the Brioqry.Tbl as reference. Hyperion 9.3 has been installed on my computer. C:\Windows\System32\brioqry.tlb is reference in the application. When I create a new instance of BrioQry in VB.Net I get a comObject error.

Dim objBqyApp As BrioQry.Application
objBqyApp = New BrioQry.Application

Error Message

Unable to cast COM object of type 'System.__ComObject' to interface type 'BrioQry.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{5D2B9A02-4F48-11D2-B1A6-00104B67DFD5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))."

1 Answer

0 votes
answered by (264k points)

This is a sample code I have found on various website. Besides the code you have pasted, there is another thing you need to mention. Use the sample one and continue forward:

Dim obj As New BrioQry.Application 
Dim doc As BrioQry.Document 
Dim querysection As BrioQry.Section 

Set doc = obj.Documents.Open("C:\Program Files\Brio\BrioQuery\Sandbox.bqy") 
Set querysection = doc.Sections.Item("Query")
commented by (100 points)
Wrong, is is the code for Visual Basic 6.0. When I try to run it in VB.Net I get the error on the line

Dim objBqyApp as New BrioQry.Application

I need to know the code changes for VB.Net and if there is a dll or reference change

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register