-
SQL connection via Tornado
I tried all the ways in the manual, and examples, even this one below
I have tried making the Global.aspx file several ways (below):
I still get this error
"Expected ''"
HELP?><>?><?!!
Sub Page_Load(Source As Object,e As EventArgs)
--------------------^
Grid test page.
<script language="VBScript" runat="server">
Sub Page_Load(Source As Object,e As EventArgs)
Dim Grid1 As New Tornado.Z()
with Grid1
.dbQP = "Unit=1|DSN=Application("IT"|Mode=Grid"
.dbGridDisplayFlds ="ID,Serial,Cost"
.dbSQL = "Select * From [Central Iowa Equipment]"
.dbTextHolder = "Title=Get the damn thing working"
end with
Grid1.ASPdbNet
End Sub
</script>
Global.aspx file
<script language="VBScript" runat="server">
Sub Application_Start(ByVal Source As Object, ByVal e As EventArgs)
Application("IRM_ConnectionString" = "DSN=IT;DRIVER={SQL Server};UID=sa"
Application("IRM_ConnectionTimeout" = 15
Application("IRM_CommandTimeout" = 30
Application("IRM_CursorLocation" = 3
Application("IRM_RuntimeUserName" = "sa"
Application("IRM_RuntimePassword" = ""
End Sub
</Script>
-
SQL connection via Tornado (reply)
Ran TornadoInfo.aspx and found the following error showed up:
The located assembly's manifest definition does not match the assembly reference
Line 199: <add assembly = "*"/>
source file: c:winntmicrosoft.netframeworkv1.0.3705Configmachin e.config
------------
jimpresley at 9/9/2002 2:53:47 PM
I tried all the ways in the manual, and examples, even this one below
I have tried making the Global.aspx file several ways (below):
I still get this error
"Expected ''"
HELP?><>?><?!!
Sub Page_Load(Source As Object,e As EventArgs)
--------------------^
Grid test page.
<script language="VBScript" runat="server">
Sub Page_Load(Source As Object,e As EventArgs)
Dim Grid1 As New Tornado.Z()
with Grid1
.dbQP = "Unit=1|DSN=Application("IT"|Mode=Grid"
.dbGridDisplayFlds ="ID,Serial,Cost"
.dbSQL = "Select * From [Central Iowa Equipment]"
.dbTextHolder = "Title=Get the damn thing working"
end with
Grid1.ASPdbNet
End Sub
</script>
Global.aspx file
<script language="VBScript" runat="server">
Sub Application_Start(ByVal Source As Object, ByVal e As EventArgs)
Application("IRM_ConnectionString" = "DSN=IT;DRIVER={SQL Server};UID=sa"
Application("IRM_ConnectionTimeout" = 15
Application("IRM_CommandTimeout" = 30
Application("IRM_CursorLocation" = 3
Application("IRM_RuntimeUserName" = "sa"
Application("IRM_RuntimePassword" = ""
End Sub
</Script>
-
SQL connection via Tornado (reply)
Hi Jim,
Did you get a global.aspx file with your installation? If so, it should be syntactically correct.
It sounds like your second post is having a problem running the tornadoinfo.aspx file? That file does not reference the global.asax file at all.
Here's what you should do:
1) Make sure you've installed the whole product underneath your web server root directory
2) Make sure you've installed the .NET runtime, MDAC 2.7, and if running Windows 2000, service pack 2 or later.
After that, you should be able to run the tornadoinfo.aspx and see the output that validates that everything is setup correctly.
If not, let us know your errors and we'll try something else.
One more thing, if this fails, try it on another server. Maybe something is installed on that machine that's preventing it from running .NET properly?
Thanks,
John
------------
jimpresley at 9/9/2002 2:53:47 PM
I tried all the ways in the manual, and examples, even this one below
I have tried making the Global.aspx file several ways (below):
I still get this error
"Expected ''"
HELP?><>?><?!!
Sub Page_Load(Source As Object,e As EventArgs)
--------------------^
Grid test page.
<script language="VBScript" runat="server">
Sub Page_Load(Source As Object,e As EventArgs)
Dim Grid1 As New Tornado.Z()
with Grid1
.dbQP = "Unit=1|DSN=Application("IT"|Mode=Grid"
.dbGridDisplayFlds ="ID,Serial,Cost"
.dbSQL = "Select * From [Central Iowa Equipment]"
.dbTextHolder = "Title=Get the damn thing working"
end with
Grid1.ASPdbNet
End Sub
</script>
Global.aspx file
<script language="VBScript" runat="server">
Sub Application_Start(ByVal Source As Object, ByVal e As EventArgs)
Application("IRM_ConnectionString" = "DSN=IT;DRIVER={SQL Server};UID=sa"
Application("IRM_ConnectionTimeout" = 15
Application("IRM_CommandTimeout" = 30
Application("IRM_CursorLocation" = 3
Application("IRM_RuntimeUserName" = "sa"
Application("IRM_RuntimePassword" = ""
End Sub
</Script>
-
SQL connection via Tornado (reply)
Okay, I went into NET frame config mgmt, and added Tornado.dll to the
applications. I then ran TornadoInfo.aspx and it ran fine now.
I still get the following:
Expected ''
Sub Page_Load(Source AS Object, E AS EventArgs)
--------------------^
when I run this little grid:
<script language= "VBScript" RUNAT ="Server">
Sub Page_Load(Source AS Object, E AS EventArgs)
DIM Grid1 AS New Tornado.Z()
Grid1.dbQP = "Unit=1|Mode=Grid"
Grid1.dbDSN = Application("IT"
Grid1.dbSQL = "SELECT ID, Serial, Cost FROM [Central Iowa Equipment]"
Grid1.dbGridDisplayflds = "ID, Serial, Cost"
Grid1.ASPdbNET
End Sub
</script>
I used the shipped Global.aspx file, with just my addition on the last
application line (Application("IT" = "VHACIHFPC15;IT;sa":
<script language="VBScript" runat=server>
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Application("NWIND" = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/Tornado/DB/NWIND.mdb"
Application("PUBS" = "fkw;pubs;sa;sa"
Application("Paradox" = "Driver={Microsoft Paradox Driver (*.db )};UserCommitSync=Yes; FIL=Paradox 5.X; driverID=538; MaxScanRows=5; DefaultDir=" & Server.MapPath("/Tornado/DB"
Application("Excel" = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & Server.MapPath("/Tornado/DB/Quotes.xls"
Application("Csv" = "Provider=Microsoft.Jet.OLEDB.4.0; Extended Properties=Text; Data Source=" & Server.MapPath("/tornado/DB"
Application("IT" = "VHACIHFPC15;IT;sa"
End Sub
Sub Session_End(ByVal sender As Object, ByVal e As EventArgs)
Dim UserSession As ArrayList = Application("UserSession"
Dim NamePassword As ArrayList = Application("NamePassword"
Dim who As Integer = UserSession.IndexOf(Session.SessionID)
UserSession.RemoveAt(who)
NamePassword.RemoveAt(who)
Application("UserSession" = UserSession
Application("NamePassword" = NamePassword
End Sub
</Script>
------------
jimpresley at 9/9/2002 2:53:47 PM
I tried all the ways in the manual, and examples, even this one below
I have tried making the Global.aspx file several ways (below):
I still get this error
"Expected ''"
HELP?><>?><?!!
Sub Page_Load(Source As Object,e As EventArgs)
--------------------^
Grid test page.
<script language="VBScript" runat="server">
Sub Page_Load(Source As Object,e As EventArgs)
Dim Grid1 As New Tornado.Z()
with Grid1
.dbQP = "Unit=1|DSN=Application("IT"|Mode=Grid"
.dbGridDisplayFlds ="ID,Serial,Cost"
.dbSQL = "Select * From [Central Iowa Equipment]"
.dbTextHolder = "Title=Get the damn thing working"
end with
Grid1.ASPdbNet
End Sub
</script>
Global.aspx file
<script language="VBScript" runat="server">
Sub Application_Start(ByVal Source As Object, ByVal e As EventArgs)
Application("IRM_ConnectionString" = "DSN=IT;DRIVER={SQL Server};UID=sa"
Application("IRM_ConnectionTimeout" = 15
Application("IRM_CommandTimeout" = 30
Application("IRM_CursorLocation" = 3
Application("IRM_RuntimeUserName" = "sa"
Application("IRM_RuntimePassword" = ""
End Sub
</Script>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|