[Mono-bugs] [Bug 43423][Blo] New - MS SQL Server hangs Aspx Page
bugzilla-daemon@rocky.ximian.com
bugzilla-daemon@rocky.ximian.com
Tue, 20 May 2003 19:28:58 -0400 (EDT)
Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.
Changed by ljones@lithonia.com.
http://bugzilla.ximian.com/show_bug.cgi?id=43423
--- shadow/43423 Tue May 20 19:28:58 2003
+++ shadow/43423.tmp.17144 Tue May 20 19:28:58 2003
@@ -0,0 +1,74 @@
+Bug#: 43423
+Product: Mono/Runtime
+Version: unspecified
+OS: Red Hat 9.0
+OS Details:
+Status: NEW
+Resolution:
+Severity:
+Priority: Blocker
+Component: misc
+AssignedTo: mono-bugs@ximian.com
+ReportedBy: ljones@lithonia.com
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL:
+Cc:
+Summary: MS SQL Server hangs Aspx Page
+
+Description of Problem:
+Aspx page hangs when try to access MS SQL Server
+
+Steps to reproduce the problem:
+1. Pull up this aspx page:
+<%@ Import Namespace="System.Data" %>
+<%@ Import Namespace="System.Data.SqlClient" %>
+<%@ Page Language="C#" %>
+
+
+<script runat="server">
+public void Page_Load()
+{
+ SqlDataReader reader;
+ string connectionString = "Server=SERVER;Database=pubs;User
+ID=sa;Password=password";
+ SqlConnection dbcon;
+ dbcon = new SqlConnection(connectionString);
+ dbcon.Open();
+ SqlCommand dbcmd = dbcon.CreateCommand();
+ string sql =
+ "SELECT au_fname, au_lname " +
+ "FROM Authors";
+ dbcmd.CommandText = sql;
+ reader = dbcmd.ExecuteReader();
+ while(reader.Read()) {
+ string FirstName = reader["au_fname"].ToString();
+ string LastName = reader["au_lname"].ToString();
+ Console.WriteLine("Name: " + FirstName + " " + LastName);
+ }
+
+ reader.Close();
+ dbcon.Close();
+
+ }
+</script>
+<Html>
+ <Body>
+ <H2>Testing Sql</H2>
+ </Body>
+</Html>
+
+Actual Results:
+page hangs, never comes up
+
+Expected Results:
+Display author names on web page
+
+How often does this happen?
+every time
+
+Additional Information:
+The PUBS data base comes on all MS SQL Server installs as a standard
+sample database. If the code is tested with MS SQL Server the db will be
+there; no setup needed. Replace SERVER with the real Server Name,
+and 'password' with the real password.