Solved

Viewing Access ASP forms remotely

Posted on 1998-04-27
14
273 Views
Last Modified: 2013-12-25
I have Access 97 and IIS 4 on the same NT server.
I've used Access ASP export functions to make
Web pages that can reach the dbase from IE3/4.

From some remote WinNT or Win95 machines, I can
go ahead and view the forms as expected.

From other machines I get a gray box about 1/3 the
size of my actual forms, and its blank.

Going to Microsoft's KB article "If you have a blank
page", I follow all their suggestions with no result.

However, I have noticed that one file that they mention
that must be installed (isctrls.ocx) is  117 KB on the systems that don't work and 125 KB on the systems that do. So I put the newer, bigger version on a machine which didn't work and it still doesn't.

Any thoughts??
0
Comment
Question by:sglanger
  • 7
  • 7
14 Comments
 
LVL 3

Expert Comment

by:hkp
ID: 1854237
About, the isctrls.ocx. If you are using this control, then you should install it the proper way. The registry entries should be updated, as each new version of a COM component, actually, get a new GUID (globally unique identifier!) I can imagine this is the real problem. Hence, some of the new features of the newer
component are not registered after a normal copy.

If this is not the answer. Could you send the source file?

0
 

Author Comment

by:sglanger
ID: 1854238
Well, I didn't just copy over the file. I copied it over
and updated the registry with regxxx.exe (whatever the
name of the tool is) as per the instruction in the
Microsoft KB article on "If your form is blank".

As for the source, what source would you like to see?
The MS-Access generated ASPs that I'm using?
 
I get the same problem with the example files that come
with the IIS4 upgrade. There is an database example
(Advwprks.mdb created during the IIS4 option pack install).

When viewed from some machines, the form is blank, on others
its fine. What ever the problem is, its definately on the
client side, not the server.
0
 

Author Comment

by:sglanger
ID: 1854239
As per hkp's request, here is the Access '97 .asp
and alx.asp files that work on some, but not all
remote client machines.

Good luck

*******
the .asp file

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>

<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 2.0">
<title>multiformatters</title>
</head>

<body>
<%
If IsObject(Session("radnetclinical_conn")) Then
    Set conn = Session("radnetclinical_conn")
Else
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "radnetclinical","",""
    Set Session("radnetclinical_conn") = conn
End If
%><%
If IsObject(Session("Form_multiformatters_rs")) Then
    Set rs = Session("Form_multiformatters_rs")
Else
    sql = "SELECT * FROM [multiformatters]"
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn, 3, 3
    If rs.eof Then
        rs.AddNew
    End If
    Set Session("Form_multiformatters_rs") = rs
End If
%><%

If cstr(Request.QueryString("Building")) <> "" Then
    rs.Fields("Building").Value = Request.QueryString("Building")
End If
If cstr(Request.QueryString("in_6")) <> "" Then
    rs.Fields("in_6").Value = Request.QueryString("in_6")
End If
If cstr(Request.QueryString("in_5")) <> "" Then
    rs.Fields("in_5").Value = Request.QueryString("in_5")
End If
If cstr(Request.QueryString("in_4")) <> "" Then
    rs.Fields("in_4").Value = Request.QueryString("in_4")
End If
If cstr(Request.QueryString("in_3")) <> "" Then
    rs.Fields("in_3").Value = Request.QueryString("in_3")
End If
If cstr(Request.QueryString("in_2")) <> "" Then
    rs.Fields("in_2").Value = Request.QueryString("in_2")
End If
If cstr(Request.QueryString("in_1")) <> "" Then
    rs.Fields("in_1").Value = Request.QueryString("in_1")
End If
If cstr(Request.QueryString("out_2")) <> "" Then
    rs.Fields("out_2").Value = Request.QueryString("out_2")
End If
If cstr(Request.QueryString("out_1")) <> "" Then
    rs.Fields("out_1").Value = Request.QueryString("out_1")
End If
If cstr(Request.QueryString("#_Channels")) <> "" Then
    rs.Fields("#_Channels").Value = Request.QueryString("#_Channels")
End If
If cstr(Request.QueryString("Vendor")) <> "" Then
    rs.Fields("Vendor").Value = Request.QueryString("Vendor")
End If
If cstr(Request.QueryString("Model")) <> "" Then
    rs.Fields("Model").Value = Request.QueryString("Model")
End If
If cstr(Request.QueryString("ID")) <> "" Then
    rs.Fields("ID").Value = Request.QueryString("ID")
End If
If cstr(Request.QueryString("room")) <> "" Then
    rs.Fields("room").Value = Request.QueryString("room")
End If


tempVar = Request.QueryString("nav_btn")
On Error Resume Next
If cstr(tempVar)="nav_btn_MoveFirstRecord" Then
    rs.MoveFirst
End If
If cstr(tempVar)="nav_btn_MovePrevRecord" Then
    rs.MovePrevious
    If rs.bof Then
        rs.MoveNext
    End If
End If
If cstr(tempVar)="nav_btn_MoveNextRecord" Then
    rs.MoveNext
    If rs.eof Then
        rs.MovePrevious
    End If
End If
If cstr(tempVar)="nav_btn_MoveLastRecord" Then
    rs.MoveLast
End If
If cstr(tempVar)="nav_btn_MoveAddRecord" Then
    rs.AddNew
End If
If cstr(tempVar)="nav_btn_MoveCommitRecord" Then
    rs.Update
    rs.Requery
End If
If cstr(tempVar)="nav_btn_MoveCancelUpdate" Then
    rs.CancelUpdate
    rs.Resync
End If
If cstr(tempVar)="nav_btn_MoveDeleteRecord" Then
    rs.Delete
    rs.MoveNext
    If rs.eof Then
        rs.MovePrevious
        If rs.bof Then
            rs.AddNew
        End If
    End If
End If
On Error Goto 0
%><object id="radnet_multiformatters_falx"
classid="CLSID:812AE312-8B8E-11CF-93C8-00AA00C08FDF"
align="baseline" border="0" width="151" height="113"
style="TOP:0;LEFT:0;"><param name="ALXPATH"
value="http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-falx.asp"></object>
</body>
</html>


*****
the matching alx.asp file

<%
If IsObject(Session("radnetclinical_conn")) Then
    Set conn = Session("radnetclinical_conn")
Else
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "radnetclinical","",""
    Set Session("radnetclinical_conn") = conn
End If
%>
<%
If IsObject(Session("Form_multiformatters_rs")) Then
    Set rs = Session("Form_multiformatters_rs")
Else
    sql = "SELECT * FROM [multiformatters]"
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn, 3, 3
    If rs.eof Then
        rs.AddNew
    End If
    Set Session("Form_multiformatters_rs") = rs
End If
%>
<%If Not IsNull(rs.Fields("Building").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_6").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_5").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_4").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_3").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_2").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("in_1").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("out_2").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("out_1").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("#_Channels").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("Vendor").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("Model").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("ID").Value) Then%>
<%End If%>
<%If Not IsNull(rs.Fields("room").Value) Then%>
<%End If%>
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html>

<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 2.0">
<title></title>
</head>

<body>
<script language="VBScript">
<!--
Dim rgszCtrls(24, 2)
Dim cMaxCtrls
cMaxCtrls = 24
Sub AddCtrlToList(szCtrl, szCtrlSrc)
    Dim i
    for i = 1 to cMaxCtrls
        if rgszCtrls(i, 1) = szCtrl Then Exit Sub
        if rgszCtrls(i, 1) = "" Then
            rgszCtrls(i, 1) = szCtrl
            rgszCtrls(i, 2) = szCtrlSrc
            Exit Sub
        End If
    next
End Sub

Sub UpdateRefreshBtn()
    nav_btn_MoveCancelUpdate.Caption = "Cancel"
End Sub

Function MakeHTMLValue(szVal)
    Dim i
    Dim szRet
    for i = 1 to Len(szVal)
        ch = Mid(szVal, i, 1)
        if ch = " " Then
            szRet = szRet & "%20"
        elseif ch = "&" Then
            szRet = szRet & "%26"
        elseif ch = "#" Then
            szRet = szRet & "%23"
        elseif ch = """" Then
            szRet = szRet & "%22"
        elseif ch = ";" Then
            szRet = szRet & "%3B"
        elseif ch = ":" Then
            szRet = szRet & "%3A"
        elseif ch = "'" Then
            szRet = szRet & "%27"
        else
            szRet = szRet & Mid(szVal, i, 1)
        end if
    next
    MakeHTMLValue = szRet
End Function

Function GetCtrlQueryString()
    Dim szRet
    Dim i
    for i = 1 to cMaxCtrls
        if rgszCtrls(i, 1) = "" Then Exit For
        szRet = szRet & rgszCtrls(i, 2) & "=" & MakeHTMLValue(radnet_multiformatters_falx.Controls(rgszCtrls(i, 1)).Value) & "&"
    next
    GetCtrlQueryString = szRet
End Function

Sub radnet_multiformatters_falx_OnLoad()
End Sub

Sub Building_AfterUpdate()
    call AddCtrlToList("Building", "Building")
    call UpdateRefreshBtn()
End Sub

Sub in_6_AfterUpdate()
    call AddCtrlToList("in_6", "in_6")
    call UpdateRefreshBtn()
End Sub

Sub in_5_AfterUpdate()
    call AddCtrlToList("in_5", "in_5")
    call UpdateRefreshBtn()
End Sub

Sub in_4_AfterUpdate()
    call AddCtrlToList("in_4", "in_4")
    call UpdateRefreshBtn()
End Sub

Sub in_3_AfterUpdate()
    call AddCtrlToList("in_3", "in_3")
    call UpdateRefreshBtn()
End Sub

Sub in_2_AfterUpdate()
    call AddCtrlToList("in_2", "in_2")
    call UpdateRefreshBtn()
End Sub

Sub in_1_AfterUpdate()
    call AddCtrlToList("in_1", "in_1")
    call UpdateRefreshBtn()
End Sub

Sub out_2_AfterUpdate()
    call AddCtrlToList("out_2", "out_2")
    call UpdateRefreshBtn()
End Sub

Sub out_1_AfterUpdate()
    call AddCtrlToList("out_1", "out_1")
    call UpdateRefreshBtn()
End Sub

Sub __Channels_AfterUpdate()
    call AddCtrlToList("__Channels", "#_Channels")
    call UpdateRefreshBtn()
End Sub

Sub Vendor_AfterUpdate()
    call AddCtrlToList("Vendor", "Vendor")
    call UpdateRefreshBtn()
End Sub

Sub Model_AfterUpdate()
    call AddCtrlToList("Model", "Model")
    call UpdateRefreshBtn()
End Sub

Sub ID_AfterUpdate()
    call AddCtrlToList("ID", "ID")
    call UpdateRefreshBtn()
End Sub

Sub room_AfterUpdate()
    call AddCtrlToList("room", "room")
    call UpdateRefreshBtn()
End Sub

Sub nav_btn_MoveFirstRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveFirstRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MovePrevRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MovePrevRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MoveNextRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveNextRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MoveLastRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveLastRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MoveAddRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveAddRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MoveCommitRecord_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveCommitRecord&" & GetCtrlQueryString()
End Sub

Sub nav_btn_MoveCancelUpdate_Click()
    Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveCancelUpdate&"
End Sub

Sub nav_btn_MoveDeleteRecord_Click()
    If MsgBox("Press OK to delete current record", 1, "radnet-multiformatters-f") =1 Then
        Window.Location.Href = "http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-f.asp?nav_btn=nav_btn_MoveDeleteRecord&"
    End If
End Sub

-->
</script><object id="Text13"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="210" height="37"
style="TOP:12;LEFT:43;WIDTH:214;HEIGHT:38;ZINDEX:0;"><param
name="BackStyle" value="0"><param name="Caption"
value="multiformatters"><param name="ForeColor" value="16777215"><param
name="FontHeight" value="280"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="5564;988"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388627"><param
name="FontEffects" value="1"></object><object id="Text12"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="210" height="37"
style="TOP:16;LEFT:46;WIDTH:214;HEIGHT:38;ZINDEX:1;"><param
name="BackStyle" value="0"><param name="Caption"
value="multiformatters"><param name="ForeColor" value="8355711"><param
name="FontHeight" value="280"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="5564;988"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388627"><param
name="FontEffects" value="1"></object><object id="Building"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:535;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:13;ZINDEX:0;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("Building").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text41"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="85" height="22"
style="TOP:535;LEFT:72;WIDTH:86;HEIGHT:22;ZINDEX:1;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="Building:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="2236;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_6"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:499;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:12;ZINDEX:2;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_6").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text39"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:499;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:3;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_6:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_5"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:463;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:11;ZINDEX:4;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_5").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text37"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:463;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:5;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_5:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_4"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:427;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:10;ZINDEX:6;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_4").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text35"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:427;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:7;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_4:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_3"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:391;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:9;ZINDEX:8;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_3").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text33"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:391;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:9;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_3:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_2"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:355;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:8;ZINDEX:10;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_2").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text31"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:355;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:11;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_2:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="in_1"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:319;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:7;ZINDEX:12;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("in_1").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text29"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:319;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:13;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="in_1:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="out_2"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:283;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:6;ZINDEX:14;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("out_2").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text27"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:283;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:15;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="out_2:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="out_1"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:247;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:5;ZINDEX:16;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("out_1").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text25"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:247;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:17;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="out_1:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="__Channels"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:211;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:4;ZINDEX:18;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("#_Channels").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text23"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="113" height="22"
style="TOP:211;LEFT:43;WIDTH:115;HEIGHT:22;ZINDEX:19;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="#_Channels:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="2990;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="Vendor"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:175;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:3;ZINDEX:20;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("Vendor").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text21"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="71" height="22"
style="TOP:175;LEFT:86;WIDTH:72;HEIGHT:22;ZINDEX:21;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="Vendor:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1872;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="Model"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:139;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:2;ZINDEX:22;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("Model").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text19"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="71" height="22"
style="TOP:139;LEFT:86;WIDTH:72;HEIGHT:22;ZINDEX:23;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="Model:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1872;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="ID"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:103;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:1;ZINDEX:24;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("ID").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text17"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="28" height="22"
style="TOP:103;LEFT:129;WIDTH:28;HEIGHT:22;ZINDEX:25;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="ID:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="728;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object id="room"
classid="CLSID:8BD21D10-EC42-11CE-9E0D-00AA006002F3"
align="baseline" border="0" width="250" height="24"
style="TOP:67;LEFT:172;WIDTH:254;HEIGHT:24;TABINDEX:0;ZINDEX:26;"><param
name="Value"
value="<%=Server.HTMLEncode(rs.Fields("room").Value)%>"><param
name="BackStyle" value="1"><param name="BackColor"
value="16777215"><param name="BorderStyle" value="1"><param
name="BorderColor" value="0"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="Font"
value="MS Sans Serif"><param name="FontName"
value="MS Sans Serif"><param name="Size" value="6604;624"><param
name="SpecialEffect" value="2"><param name="VariousPropertyBits"
value="2894088219"></object><object id="Text15"
classid="CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0"
align="baseline" border="0" width="56" height="22"
style="TOP:67;LEFT:100;WIDTH:57;HEIGHT:22;ZINDEX:27;"><param
name="BackStyle" value="1"><param name="BackColor"
value="12632256"><param name="Caption" value="room:"><param
name="ParagraphAlign" value="2"><param name="ForeColor" value="0"><param
name="FontHeight" value="160"><param name="FontWeight"
value="700"><param name="Font" value="MS Sans Serif"><param
name="FontName" value="MS Sans Serif"><param name="Size"
value="1482;572"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="8388635"><param
name="FontEffects" value="1"></object><object
id="nav_btn_MoveCancelUpdate"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="83" height="28"
style="TOP:572;LEFT:336;WIDTH:84;HEIGHT:28;ZINDEX:0;"><param
name="BackStyle" value="0"><param name="Caption" value="Refresh"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="2184;728"><param name="SpecialEffect"
value="0"><param name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveDeleteRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="83" height="28"
style="TOP:572;LEFT:252;WIDTH:84;HEIGHT:28;ZINDEX:1;"><param
name="BackStyle" value="0"><param name="Caption" value="Delete"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="2184;728"><param name="SpecialEffect"
value="0"><param name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveCommitRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="83" height="28"
style="TOP:572;LEFT:168;WIDTH:84;HEIGHT:28;ZINDEX:2;"><param
name="BackStyle" value="0"><param name="Caption" value="Commit"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="2184;728"><param name="SpecialEffect"
value="0"><param name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveAddRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="28" height="28"
style="TOP:572;LEFT:112;WIDTH:28;HEIGHT:28;ZINDEX:3;"><param
name="BackStyle" value="0"><param name="Caption" value="&gt;*"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="728;728"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveLastRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="28" height="28"
style="TOP:572;LEFT:84;WIDTH:28;HEIGHT:28;ZINDEX:4;"><param
name="BackStyle" value="0"><param name="Caption" value="&gt;|"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="728;728"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveNextRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="28" height="28"
style="TOP:572;LEFT:56;WIDTH:28;HEIGHT:28;ZINDEX:5;"><param
name="BackStyle" value="0"><param name="Caption" value="&gt;"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="728;728"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MovePrevRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="28" height="28"
style="TOP:572;LEFT:28;WIDTH:28;HEIGHT:28;ZINDEX:6;"><param
name="BackStyle" value="0"><param name="Caption" value="&lt;"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="728;728"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="2"></object><object
id="nav_btn_MoveFirstRecord"
classid="CLSID:D7053240-CE69-11CD-A777-00DD01143C57"
align="baseline" border="0" width="28" height="28"
style="TOP:572;LEFT:0;WIDTH:28;HEIGHT:28;ZINDEX:7;"><param
name="BackStyle" value="0"><param name="Caption" value="|&lt;"><param
name="ParagraphAlign" value="3"><param name="ForeColor" value="0"><param
name="Size" value="728;728"><param name="SpecialEffect" value="0"><param
name="VariousPropertyBits" value="2"></object>
</body>
</html>


0
 

Author Comment

by:sglanger
ID: 1854240
Adjusted points to 200
0
 
LVL 3

Expert Comment

by:hkp
ID: 1854241
The problem lies in the ActiveX component's presence in a combination with the related DLL file(s). But, I have been told, it is possible to reach out on the Internet for a codebase with so called .CAB files, which are like .ZIP files. This can be set in the <OBJECT> tag.
I'm currently investigating the problem, while I have the same problem with ASP files generated from Access 97 HTML wizard.
I'll be back. Have patience.  :-)
0
 
LVL 3

Expert Comment

by:hkp
ID: 1854242
Try to run the following exe file on a computer with the given problem.

http://usersupport.smsu.edu/library/internet/msie/setupslt.exe

I believe, this will do the trick. Don't try to overwrite files of newer dates.

Good luck.
0
 
LVL 3

Expert Comment

by:hkp
ID: 1854243
Please, forget the proposed answer, as I have a far better solution.

The OBJECT tag needs a way to know from where the controls can be downloaded to the client. For this you use CODEBASE=<url> (see below). If you fetch the file mspert10.cab to c:\, you can speed up the process, by using a "file://c|/mspert10.cab" in the place of the <url>. Like, CODEBASE=file://c|/mspert10.cab

Snip of your program from above. remark the line with "codebase=..."
----------
..
..
..
On Error Goto 0
%><object id="radnet_multiformatters_falx"
classid="CLSID:812AE312-8B8E-11CF-93C8-00AA00C08FDF"
codebase=http://activex.microsoft.com/controls/mspert10.cab
align="baseline" border="0" width="151" height="113"
style="TOP:0;LEFT:0;"><param name="ALXPATH"
value="http://fibonacci.rad.washington.edu/cgi-bin/radnet-multiformatters-falx.asp"></object>
</body>
</html>
---------

:-)
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:sglanger
ID: 1854244
hkp;
 Well I tried what you typed with great hopes, but
the remote machines that were blank before still are.
Does the code render for you (I know you won't get
the data, but the format)?
0
 
LVL 3

Expert Comment

by:hkp
ID: 1854245
Yes, the code renders, but I also have the Microsoft HTML Layout Control on my machines. Both Windows 95, and Windows NT 4.0 (Workstation and Server).

Are your sure, the browsers on the remote machines are setup to activate

Now, it seems like another issue. Perhaps a connectivity question or a browser setup question. Do the remote machines have access to the Internet? If they don't try to make the mspert10.cab file available to the browsers by copying the file to a place on the server where the remote machines have read permissions. Set the codebase to the location where you have access to the mspert10.cab file.

The browser also can have deactivated the possibility to get, or start the ActiveX components. Try to set these settings to activated - however, this is low security, and should normally, be avoided on the Internet.

If you get the remote machines up, I will make a new improved answer.
0
 

Author Comment

by:sglanger
ID: 1854246
Hey, the 1'st answer you gave yesterday worked!
[running setupslt.exe]

i couldn't read it yesterday though. For some reason the
box said "See above text" so i tried your following
comment about the code base, which didn't work.

If you resubmit the setupslt.exe answer, I'll give you an "A"
Now what did the thing do?

0
 
LVL 3

Accepted Solution

by:
hkp earned 200 total points
ID: 1854247
Ok, I know this is working, but I like the idea of Distributed Component Object Model, so I don't see why the codebase addressing technique doesn't work on your remote computers. But the answer which works is this:

Try to run the following exe file on a computer with the given problem.

http://usersupport.smsu.edu/library/internet/msie/setupslt.exe

I believe, this will do the trick. Don't try to overwrite files of newer dates.

:-)
0
 

Author Comment

by:sglanger
ID: 1854248
hkp
 Where did you find out about this usersupport.smsu.edu
site and about this patch file in particular?


0
 
LVL 3

Expert Comment

by:hkp
ID: 1854249
Intuition, my friend. Simply, by looking for "HTML Layout Control", or the Class Id on the Web.

I knew, my own problem was like yours, and I thought that the problem could be either wrong version, or missing files.

I hope you get the codebase version to work, it's less vulnerable to missing files on the computer.

;-)
0
 

Author Comment

by:sglanger
ID: 1854250
My guess is that on the machines that failed to work, they
couldn't use the codebase fix for the same reason that they
couldn't render my forms. Now that I have that level of
functionality on them, the codebase include probably will
work.

BTW, I looked for HTML layout control too, that's how I found
the KB article that mentioned the one *.ocx file. However,
that update of the existing file on the failing machines
didn't solve the problem either (as chronicled above)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Problem to be resolved in this article Currently, development of website and web application can be done without writing thousands of lines of programming code by hand. Description This can be done through by using a open source framework such …
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now