Ravikanth,
Point 2 has made the system work - which is good.... However what will
happen when I start to get numerous users of the system?
Many thanks, Carl
"Ravikanth[MVP]" <dvravikanth@hotmail.com> wrote in message
news:07b101c35d9d$ba7e3db0$a601280a@phx.gbl...[color=blue]
> Hi
>
> Try to change your SQL Statement by adding/removing ORDER
> BY, WHERE..... if it solves the problem, it means that
> your sql statement does not return data in the normal
> manner.... i.e. slower than ADO.NET expect.
>
> 2. If you are using simultanious connections, you might
> have some problem about connection pooling, try to add
> Pooling=false in Sql connection string. If this is the
> problem, make sure that you use the exact same Sql
> statement everywhere......
>
> 3. But if you are using Trusted Connection and set
> pooling to true right now, but you also set
> impersonation=true. The problem is that it will login
> using different accounts causing the connection pool to
> be useless. You might either use SQL account or set
> Pooling = false in the connection string to solve the
> problem.
>
>
> Check out the following URL
> also:
http://forums.devshed.com/archive/52/2003/01/4/49612
>
> Ravikanth[MVP]
>
>[color=green]
> >-----Original Message-----
> >Hello again everyone..... I'm a real pain and keep[/color]
> posting re the same[color=green]
> >thing, but it is possibly the most frustrating issue[/color]
> I've come across.[color=green]
> >Please see my original post - can anybody think of a[/color]
> solution to this? The[color=green]
> >main error I experience is an sqlexception[/color]
> saying 'General Network Error',[color=green]
> >but as this is sporadic, and due to the fact that asp3[/color]
> apps work fine I am[color=green]
> >at a total loss as to what the issue can be.
> >
> >In addition to this I connect to the database using the[/color]
> following:[color=green]
> >
> >The connections in the current activity (SQL) show[/color]
> as 'sleeping', which[color=green]
> >suggests
> >to me that the connections have been closed.
> >
> >I am using a component to access the database, based on[/color]
> the following:[color=green]
> >Public ReadOnly Property ConnectionString()
> >
> >Get
> >
> >ConnectionString = "Data Source=10.200.20.2; Initial[/color]
> Catalog=ClientCAS;User[color=green]
> >ID=sa;Password=password; Network Library=dbmssocn;"
> >
> >End Get
> >
> >End Property
> >
> >
> >Public Function GetReader(ByVal strSQL As String) As[/color]
> SqlDataReader[color=green]
> >
> >Dim tmpConn As New SqlConnection(Me.ConnectionString)
> >
> >Dim objCmd As New SqlCommand(strSQL, tmpConn)
> >
> >objCmd.Connection.Open()
> >
> >objCmd.CommandTimeout = 300
> >
> >GetReader = objCmd.ExecuteReader[/color]
> (CommandBehavior.CloseConnection)[color=green]
> >
> >objCmd = Nothing
> >
> >End Function
> >
> >
> >And then within my pages' back end code I would do[/color]
> something along these[color=green]
> >lines to fill, say, a datagrid:
> >
> >dim obj as new cpData
> >dim dr as sqldatareader = obj.GetReader("spStoredProc "[/color]
> & id)[color=green]
> >dg.datasource = dr
> >dg.databind
> >dr.close
> >dr = nothing
> >obj = nothing
> >
> >---------------------->
> >Hi Gregory,
> >
> >Thanks for coming back to me. I am at a loss with this[/color]
> but will run some[color=green]
> >checks as you have suggested. The network issue really[/color]
> is confusing,[color=green]
> >certainly since the 'classic' asp applications that we[/color]
> are running do not[color=green]
> >experience this problem at all.
> >
> >Whilst testing, I have noticed that if I log into the[/color]
> system and jump[color=green]
> >between pages at frequent intervals it seems to work[/color]
> perfectly. It seems[color=green]
> >that if I leave a page displayed for any length of time[/color]
> then choose another[color=green]
> >lin k that is when the system freezes up - I don't know[/color]
> if that gives you[color=green]
> >any further clues. I have altered the web.config file[/color]
> to say debug="false",[color=green]
> >which has made no difference and have checked the code[/color]
> and I certainly[color=green]
> >believe that all objects used are being destroyed after[/color]
> use.[color=green]
> >
> >Another clue that may help is that part of the system[/color]
> is 'upgraded' classic[color=green]
> >asp, ie we have simply converted the existing asp pages[/color]
> and got rid of the[color=green]
> >'set' commands, used isdbnull instead of isnull, and[/color]
> have set aspcompat[color=green]
> >accordingly (only on converted pages), I cannot see this[/color]
> as being an issue[color=green]
> >due to the fact that these all work wonderfully on my[/color]
> machine.[color=green]
> >
> >If you have any other ideas (or not!) in relation to[/color]
> this please let me[color=green]
> >know.
> >
> >Many thanks again, Carl
> >
> >
> >"Cowboy (Gregory A. Beamer)"[/color]
> <NoSpamMgbworld@comcast.netRemuvThis> wrote in[color=green]
> >message news:%23nYjrDOXDHA.1004@TK2MSFTNGP12.phx.gbl...[color=darkred]
> >> I don't believe in unpredictable in computers, so it[/color][/color]
> is predictable, but[color=green][color=darkred]
> >> unknown.
> >>
> >> I would suggest profiling both the machine and the[/color][/color]
> application. Tracing[color=green]
> >can[color=darkred]
> >> help some, but you are going to have to examine what[/color][/color]
> the machine is doing[color=green][color=darkred]
> >> when the app is running (along with what other apps[/color][/color]
> are running and what[color=green][color=darkred]
> >> they are doing).
> >>
> >> The topology of the network can also be a major[/color][/color]
> influence. If you web[color=green]
> >server[color=darkred]
> >> has to talk to the database via a firewall, it is at a[/color][/color]
> disavantage from[color=green]
> >your[color=darkred]
> >> XP dev box. So, the DMZ can affect your app. You need[/color][/color]
> to know what it is[color=green][color=darkred]
> >> doing when it has a problem (down to the line of code[/color][/color]
> possibly, which is[color=green][color=darkred]
> >> easiest done with logging (which slows down the app[/color][/color]
> while it is[color=green][color=darkred]
> >> instituted)).
> >>
> >> I wish I had an easy answer, but there are a lot of[/color][/color]
> variables here.[color=green][color=darkred]
> >>
> >> --
> >> Gregory A. Beamer
> >> MVP; MCP: +I, SE, SD, DBA
> >> Author: ADO.NET and XML: ASP.NET on the Edge
> >>
> >>[/color]
> >************************************************* ********[/color]
> *******************[color=green][color=darkred]
> >> ****
> >> Think Outside the Box!
> >>[/color]
> >************************************************* ********[/color]
> *******************[color=green][color=darkred]
> >> ****
> >> "Carl Howarth" <carl.howarth@m-s-solutions.co.uk>[/color][/color]
> wrote in message[color=green][color=darkred]
> >> news:OClO$tNXDHA.2392@TK2MSFTNGP10.phx.gbl...
> >> > Sorry to repost, but I am fairly desparate to get[/color][/color]
> this issue resolved![color=green][color=darkred]
> >> >
> >> > Please see below, when it hangs if I leave it long[/color][/color]
> enough I get a[color=green]
> >'General[color=darkred]
> >> > Network Error', or something similar. Could this be[/color][/color]
> down to the web[color=green][color=darkred]
> >> servers
> >> > being on the DMZ, or perhaps some configuration[/color][/color]
> value in the web.config[color=green][color=darkred]
> >> > file?
> >> >
> >> > Any help would really be appreciated as I am due to[/color][/color]
> put the system live[color=green][color=darkred]
> >> > ASAP.
> >> >
> >> > Many thanks, Carl Howarth
> >> >
> >> >
> >> > Hi,
> >> >
> >> > We have developed a system using VS.NET 2003 in[/color][/color]
> ASP.NET (vb). The system[color=green][color=darkred]
> >> > runs absolutely fine on my own and my colleague's[/color][/color]
> machine. We are[color=green]
> >running[color=darkred]
> >> > Win XP Pro. We have 2 web servers, each of which[/color][/color]
> have been upgraded to[color=green][color=darkred]
> >> .net
> >> > 1.1, and have all the latest updates from windows[/color][/color]
> update.[color=green][color=darkred]
> >> >
> >> > When we deploy the application to either web server[/color][/color]
> the performance is[color=green][color=darkred]
> >> > ridiculous (the servers run asp3 systems fine).[/color][/color]
> Sometimes the system[color=green]
> >will[color=darkred]
> >> > work like a dream, moving from page to page in an[/color][/color]
> instant, others it[color=green]
> >will[color=darkred]
> >> > just hang when a link is selected (even to pages[/color][/color]
> that are not accessing[color=green][color=darkred]
> >> our
> >> > database). It's nothing to do with connections[/color][/color]
> being left open and it's[color=green][color=darkred]
> >> > bizarre how the issues are completely[/color][/color]
> unpredictable. The systems are[color=green][color=darkred]
> >> > transferred simply by copying the contents of the[/color][/color]
> web site folder on our[color=green][color=darkred]
> >> > machines to the web site folder on the server(s).
> >> >
> >> > Has anybody come across this kind of situation and[/color][/color]
> if so, please please[color=green][color=darkred]
> >> let
> >> > me know how to get around it!
> >> >
> >> > Thanks very much,
> >> >
> >> > Carl Howarth
> >> >
carl.howarth@m-s-solutions.co.uk
> >> >
> >> >
> >>
> >>[/color]
> >
> >
> >
> >.
> >[/color][/color]
