Reply to thread

Message: [QUOTE="Steven Cheng[MSFT], post: 479080"] Hi Tim, AS you mentioned that this works with someone but not with some others and other members has pointed that it is possibly the Dataset is not retireved correclty, I'm suspecting that whether you've use impersonating in your web application so that your sql connecting operation will fail when running under certain client user's security context? Anyway, you can have a check in your web application's secuirty setting also. Thanks, Regards, Steven Cheng Microsoft Online Support Get Secure! [URL="http://www.microsoft.com/security"]www.microsoft.com/security[/URL] (This posting is provided "AS IS", with no warranties, and confers no rights.) -------------------- | Thread-Topic: Urgent Help for release... | thread-index: AcWvtC4pgUrYo+ICTMOvfKxkjYbZdg== | X-WBNR-Posting-Host: 62.254.216.185 | From: =?Utf-8?B?TWlsb3N6IFNrYWxlY2tp?= <MiloszSkalecki@discussions.microsoft.com> | References: <3FAC9EEA-A411-44FA-A1AE-82C5B2BDB85F@microsoft.com> <8B8DC509-6F81-4804-B05C-308A20A8F334@microsoft.com> <83D5CE22-447A-4170-9E1F-982F85416B8B@microsoft.com> | Subject: RE: Urgent Help for release... | Date: Fri, 2 Sep 2005 04:48:05 -0700 | Lines: 83 | Message-ID: <A83E9EC0-694B-4A0B-B795-2BCA887DD5A5@microsoft.com> | MIME-Version: 1.0 | Content-Type: text/plain; | charset="Utf-8" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Content-Class: urn:content-classes:message | Importance: normal | Priority: normal | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 | Newsgroups: microsoft.public.dotnet.framework.aspnet | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250 | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.framework.aspnet:121976 | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet | | Can you paste code of the GetDataSet method? | -- | Milosz Skalecki | MCP, MCAD | | | "Tim::.." wrote: | | > It works fine on my development network but for some reason it doesn't work | > when multiple users start to use it... | > | > It is almost like only certain clients get connections to the SQL server??? | > | > Any ideas??? | > | > Thanks.... | > | > "Milosz Skalecki" wrote: | > | > > Elo, | > > | > > Ensure rowId is properly set and GetDataSet does not return null reference. | > > | > > -- | > > Milosz Skalecki | > > MCP, MCAD | > > | > > | > > "Tim::.." wrote: | > > | > > > Can someone please tell me why I keep getting the following error for some of | > > > my web application users but not others??? Even though the application runs | > > > from a central webserver??? | > > > | > > > | > > > Thanks for any help... | > > > | > > > Error: | > > > ----- | > > > | > > > Exception Details: System.NullReferenceException: Object reference not set | > > > to an instance of an object. | > > > | > > > Source Error: | > > > | > > > An unhandled exception was generated during the execution of the current web | > > > request. Information regarding the origin and location of the exception can | > > > be identified using the exception stack trace below. | > > > | > > > Stack Trace: | > > > | > > > [NullReferenceException: Object reference not set to an instance of an | > > > object.] | > > > cpncms_v1.editor.GetDocument() +277 | > > > cpncms_v1.editor.Page_Load(Object sender, EventArgs e) +122 | > > > System.Web.UI.Control.OnLoad(EventArgs e) +67 | > > > System.Web.UI.Control.LoadRecursive() +35 | > > > System.Web.UI.Page.ProcessRequestMain() +731 | > > > | > > > Code: | > > > --------- | > > > | > > > Private Function GetDocument() As String | > > > Dim ds As DataSet | > > > | > > > If Request.ServerVariables("HTTP_REFERER") = | > > > "[URL]http://localhost/cpncms_v1/cms/viewpage.aspx[/URL]" Then | > > > ds = GetDataSet(("SELECT content FROM tblPageContent WHERE | > > > pageID=" + rowID.ToString())) | > > > Cache("iNews") = "False" | > > > ElseIf Request.ServerVariables("HTTP_REFERER") = | > > > "[URL]http://localhost/cpncms_v1/cms/news/pgeEditor.aspx[/URL]" Then | > > > ds = GetDataSet(("SELECT content FROM tblNewsArchive WHERE | > > > newsID=" + rowID.ToString())) | > > > Cache.Remove("iNews") | > > > End If | > > > Dim table As DataTable = ds.Tables(0) | > > > Dim row As DataRow = table.Rows(0) | > > > Dim doc As String = row("content").ToString() | > > > Return doc | > > > ds.Dispose() | > > > End Function 'GetDocument | > > > | [/QUOTE]

Verification