Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Webfocus connection from MS access
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Webfocus connection from MS access
 Login/Join
 
Member
posted
Hi,

I have created a form in MS access. On submit the form I need to call procedure. Anybody have idea on this..

Thanks,

Webfocus 7.1, MS Access(UI)

This message has been edited. Last edited by: Kerry,
 
Posts: 21 | Registered: June 08, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Don't know how MS Access works, but you might be able to construct a URL that will do this.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Access use the same VBA set that Excel does. You will likely have to create a module or macro in Access to do what you want.


WF 7703M, XP/Win7, MRE, RC, BID, PMF, HTML, PDF, Excel 2000/7/10
 
Posts: 73 | Location: NY | Registered: February 06, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
You should be able to create a URL that points to your Web FOCUS servlet (normally in ibi_apps/WFServlet - you may need to qualify where ibi_apps lives). To thsi servlet, pass the reporting server name (or take the default), the focexec name (provided it is in a folder/directory in the app path), and any parameters that the focexec needs. That should do it.


Diptesh
WF 7.1.7 - AIX, MVS
 
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Hi All,

Thanks for your replies,

I am using following code to hit webfocus server. But It is not working. Could anybody provide some sample code to connect to webfocus server.

Private Sub Command0_Click()
Dim sUrl As String
sUrl = "/ibi_apps/WFServlet? IBIF_ex=car.fex &IBIAPP_APP=foldername &IBIC_server=BIWC01 "


FollowHyperlink sUrl
End Sub

Thanks,
 
Posts: 21 | Registered: June 08, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
sUrl = "/ibi_apps/WFServlet? IBIF_ex=car.fex &IBIAPP_APP=foldername &IBIC_server=BIWC01 "
Srini,

Firstly try to understand how the url will function and where you have to direct it. Then you might be able to get your requirement working.

As a hint, What webserver are you expecting to hit?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5617 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
as a further hint remove the spaces from your url....


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Webfocus connection from MS access

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.