running out of swimming *pool* space..... ???
-
ok, so really, Here's the error message: "Failed to Connect to the Database!Timeout expired. The timeout period elaspsed prior to obtaining a connection from the pool. This may have occurred because all polled connections were in use and max pool size was reached. at System.DataSqlClient.SqlConnectionPoolManager.GetPolledConnection(SqlConnectionString options, Boolean&isInTransation) at System.Data.SqlClient.SqlConnection.Open() at WindowsApplication1.Form1.dbConnect() in c:\documents and settings\user1\desktop\windowsApplication\form1.cs:line2957" what do i need to do...i'm enumerating thru a treeView and using the node.text as a servername to create a connection to each pc(treenode). It looks like the connections to the pc's are happening much quicker than the db can store...is this possible? anyhow i could use some help.... thanks string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?
-
ok, so really, Here's the error message: "Failed to Connect to the Database!Timeout expired. The timeout period elaspsed prior to obtaining a connection from the pool. This may have occurred because all polled connections were in use and max pool size was reached. at System.DataSqlClient.SqlConnectionPoolManager.GetPolledConnection(SqlConnectionString options, Boolean&isInTransation) at System.Data.SqlClient.SqlConnection.Open() at WindowsApplication1.Form1.dbConnect() in c:\documents and settings\user1\desktop\windowsApplication\form1.cs:line2957" what do i need to do...i'm enumerating thru a treeView and using the node.text as a servername to create a connection to each pc(treenode). It looks like the connections to the pc's are happening much quicker than the db can store...is this possible? anyhow i could use some help.... thanks string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?
Are you making sure that you close connections when you are done with them? (By that I mean that the close goes in a
finallyblock so that it happens regardless of any exceptions that might be thrown (caught or not)wetrivrrat wrote:
WindowsApplication1.Form1.dbConnect()
I'm assuming by the naming here that this is a quick throw away application. If not, you should consider layering the application so that add data access happens in a data layer (a set of classes that are decoupled from the user interface). Or, to put it another way: You should not be doing any database interaction from your form class. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
-
Are you making sure that you close connections when you are done with them? (By that I mean that the close goes in a
finallyblock so that it happens regardless of any exceptions that might be thrown (caught or not)wetrivrrat wrote:
WindowsApplication1.Form1.dbConnect()
I'm assuming by the naming here that this is a quick throw away application. If not, you should consider layering the application so that add data access happens in a data layer (a set of classes that are decoupled from the user interface). Or, to put it another way: You should not be doing any database interaction from your form class. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
actually, at this point its working...i found a piece of code that i accidently commented out.... :sigh: :doh: string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?