Focal Point
Microsoft Access and Web Focus

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7201030841

January 10, 2006, 11:41 AM
<obrienk2>
Microsoft Access and Web Focus
Has anyone brought up a webfoucs dash board page from within webfocus?
January 10, 2006, 11:48 AM
susannah
Obrien, how is this related to ms access ? puzzled.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 10, 2006, 11:53 AM
rubenibi
I speak from my ignorence... but if you're asking about if you can through Access to do some report without coding in WebFOCUS, i.e SQL... I suppose you can do this, if you have installed the proper ODBC in your machine.

In my home, I have WebFOCUS 7.1 and I remember, this version particularly had come installed with odbc which can be installed insiden Control Panel/Administrative Tools/Data Source.

Once installed, you could do a test from Access and see if you can access data...

No more info can't give Frowner

Hope it helps a little.



____________________________________________
Ruben Rueda
Consultant
Information Builders Iberica

Web: http://www.eruben.biz

Prod: WF 5.3.4 @ Red Hat Enterprise Linux ES 3 (Taroon Update 6) w/Oracle 9i
Test: WF 5.3.3 @ SUN Solaris 7 w/Oracle 8i
January 10, 2006, 11:54 AM
<obrienk2>
I wanted to know if anyone has used a hyperlink within MS Access to open a Webfocus launch page?
January 10, 2006, 12:03 PM
rubenibi
Confused more and more.... :P

You have an app in Access, and you want torugh a button or label, that clicking it, open and explorer instance wich loads a fex?

Something like that in VB?

 
Private Sub BtnRuben_Click()
' New instance
Set OBJ = CreateObject("InternetExplorer.Application")

OBJ.Visible = True
    
'Load a WebPage!
OBJ.navigate "/ibi_apps/WFServlet?IBIF_ex=OneFex&Par1=1&Par2=2"
End Sub


Hope it helps!!

Regards...

Time to go home here in Spain!! :P



____________________________________________
Ruben Rueda
Consultant
Information Builders Iberica

Web: http://www.eruben.biz

Prod: WF 5.3.4 @ Red Hat Enterprise Linux ES 3 (Taroon Update 6) w/Oracle 9i
Test: WF 5.3.3 @ SUN Solaris 7 w/Oracle 8i
January 10, 2006, 01:29 PM
<obrienk2>
Thanks. The hyperlink works but then when the report comes up in a separate window it asks for the login. Its like it looses its cookie. Hope that makes sense.
January 11, 2006, 04:34 AM
Tony A
O'Brien,

When a user logs into the Dashboard a session is set up with a unique session Id and then the cookie is written (basically). Are you trying to use a hyperlink from Access when the User is logged into Dashboard? To do this you would need to include the session details in the URL and that would be nigh on impossible (someone will prove me wrong).

If you just want to run a report from a hyperlink then you could use the self service approach and pass IBIC_user and IBIC_pass etc. but you would have to prompt for them and then include them in your hyperlink.



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 11, 2006, 05:40 AM
rubenibi
Yes, Tony A is right, you must pass that parameters....

One question talking about this, I usually, when I login into my app, IBIC_user and IBIC_pass are sent ina form like:

 
<form name="form1" action=IBEPGM method="post" target="ventanaAgenda">
<input type="hidden" name="IBIWF_action" value="WF_SIGNON">

<input type="hidden" name="WF_SIGNON_MESSAGE" value=" ">

<input type="hidden" size="1" maxlenght="1" name="VAR" value="3">

<input type="hidden"name="field1" size="3" disabled>

<table width="95%" border="0" cellspacing="10" cellpadding="0">
 <tr>
   <td width="28%" class="opciones">Usuario:</td>
   <td width="72%">
     <input type="text" name="IBIC_user" value="" onkeyup="rellena()">
     <input type=hidden name=usuario value="">
     <input type=hidden name=USER></td>
 </tr>
 <tr>
  <td class="opciones">Password:</td>
  <td><input type="password" name="IBIC_pass" value=""></td>
 </tr>
</table>
</form>


If I would like to do something like O'brien, I can give a direct call like /ibi_apps/WFServlet?IBIF_ex=somefex&IBIC_user=username&IBIC_pass=somepass ??



____________________________________________
Ruben Rueda
Consultant
Information Builders Iberica

Web: http://www.eruben.biz

Prod: WF 5.3.4 @ Red Hat Enterprise Linux ES 3 (Taroon Update 6) w/Oracle 9i
Test: WF 5.3.3 @ SUN Solaris 7 w/Oracle 8i
January 11, 2006, 06:09 AM
Tony A
Simple answer is yes, you should be able to do that. Try it and see.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 18, 2006, 12:15 PM
<obrienk2>
quote:
Simple answer is yes, you should be able to do that. Try it and see.

So is this the correct syntax for passing the USername and password via the URL?
https://webfocus.dcps.us/ibi_apps/worp/jsp/WORP_Views.j...e&IBIC_pass=somepass
January 18, 2006, 03:16 PM
Tony A
The parameter bit is yes, but the JSP code would have to deal with it and I'm not sure that WORP_Views.jsp actually does.

The WORP (aka Dashboard) uses different Userid and Password variables than EDA so IBIC_user and pass are unlikely to provide any function within the JSP.

Search the tech support site for Dashboard Login or the like and have a look at the WORP_loginsi.jsp code etc. to see if you can get some ideas.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 24, 2006, 04:18 PM
<obrienk2>
maynot have done it correctly but it still dropped the cookie. What I eneded up doing was when I clicked the display button on my report I brought my report up in the same window. this way it kept the cookie but if I opened the reprot in a new window it asked you to login. Hope this makes sense