I'm trying to make sure a block of code behind properly closes a connection to SQL after it's finished. But when I add the line "cmd.Connection.Close();" Visual Studio underlines "cmd" in green and says "unreachable code detected" What does that mean and how do I correct it?
[Code]....
This morning I found myself dealing with A SQL POOLING ERROR Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I did fix this with resetting my pooling and setting a pooling max =100 Anyway now Im starting to rethink how I open connections, dealing with errors and proper closing of connections Would you say this code below is a good way of opening, closing connections (even when errors occurred)
Dim Connection As SqlConnection
Dim myConn As String = (ConfigurationManager.ConnectionStrings("MyConnString").ConnectionString)
Connection = New SqlConnection(myConn)
Try
Dim DBCommand As SqlCommand
Dim dt As New DataTable()
Dim myDataSet As New DataSet
Connection.Open()
DBCommand = New SqlCommand("GetAllCategories_", Connection)
DBCommand.CommandType = CommandType.StoredProcedure
DBCommand.Parameters.Add("@HomePageID", SqlDbType.Int).Value = HiddenChosenVirtualMainID.Value
Dim mySqlAdapter As New SqlDataAdapter(DBCommand)
mySqlAdapter.Fill(dt)
SecondLevelChildDatalist.DataSource = dt
SecondLevelChildDatalist.DataBind()
Catch ex As Exception
'Error goes here
SqlConnection.ClearAllPools()
Finally
'close the connction
Connection.Close()
Connection.Dispose()
End Try
I am using a AccessDatasource for getting values from a accessdatabase for a Dropdown list. After i load the page and close it, a .ldb file is created. After wards i am not able to open the database manually. How to close the connection. I have given Network service Modify access [URL] to share permission, still no go.
View 3 Replies I have written a routine to delete a record from a table. I want to include a statement to 'close' the connection to the table but I do not know the syntex of the statement that will do this. My code is as follows:
[code]....
I am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
I am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?
View 2 RepliesI was wondering about something. I'm supporting a .NET C# application which has a number of database connections declared locally as IDbConnection with MS SQL Server and NHibernate. These connections are declared locally and not explicitly closed after a specific operation is performed. Are these connections automatically closed after the local method is executed, or could these connections be floating around somewhere? We're having semaphore max out problems, and I'm trying to see if this may be the culprit. I'm doubtful, as I believe these connections would automatically close, but thought I'd throw out hte possibility.
View 1 Repliesi have a web application that use a MySql DataBase. In a page, i have used the sqlDatasource control. The problem is that the conection with the database doesn't closed and i have a lot of open conections until show me the error that says me that the conection pool is full.
[code]....
I got an error "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond".when i am sending email when attachment.
protected void lbtn_DownloadForm_Click(object sender, EventArgs e)
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
pnlPerson.RenderControl(hw);
[code]....
I have an application written in VB.NET that sends XML to another server and it takes another XML. I am using HttpWebRequest in sending it but when I get the request stream I got this error. Please note that the application is working on my machine, but on the deployment on server I got this error.
View 4 RepliesI'm having a doozy of a problem, and can't find a solution. I have a WFC Web Service installed to a pair of servers, and accessed through a load balancer. I am accessing the service from an ASP.NET client app, also via WCF. The Client is not load balanced.I'm getting an intermittant error:
(Inner Most Exception) System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80(Middle Exception) System.Net.WebException: Unable to connect to the remote server(Outer Exception) System.ServiceModel.EndpointNotFoundException: Could not connect to http://<MYSite>/<MYApp>/<MYService>.svc.TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80.
I can reproduce this error with about 20% reliability if I execute the exact same page request on the client from 2 browsers at the same time. When the problem occurs, the successful page request returns in about 5 seconds, and the failed page request returns in about 30 seconds.I'm guessing that there is some additional latency when the load balancer decides to switch my session to another server, and that is making some timeout setting on my client to be exceeded. I need to research this performance characteristic... any thoughtsbut its not my core question.My core question is... Exactly what setting can I tweak to increase the "period of time" the "connected party" is allows to "properly respond".This is the basicHttpBinding configuration I am using on both sides of the communication:
<basicHttpBinding>
<binding name="LongerTimeout"
sendTimeout="03:00:00"
maxReceivedMessageSize="2147483647"
maxBufferPoolSize="2147483647">
<readerQuotas maxArrayLength="2147483647" maxStringContentLength="2147483647"/>
</binding>
</basicHttpBinding>
I've seen some indication that setting the receiveTimeout value on the server may help, but I set this to 1 second in a test environment, and was unable to reproduce the problem, leads me to believe its not worth a production environment change to verify this.
my code
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
[code]...
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.155.109:465Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.155.109:465Source Error:
[Code]....
Line 34: mailClient.EnableSsl = true;Line 35: mailClient.Timeout = 1000000; Line 36: mailClient.Send(mailMessage);Line 37: mailMessage.DeliveryNotificationOptions = DeliveryNotificationOptions.Delay;Line 38: mailMessage.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
Source File: d:My
WebsitesBenefitsBenefitsDefault.aspx.cs Line: 36
Stack Trace:
[Code]....
[SocketException (0x274c): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.155.109:465] System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) +239 System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +35 System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +224[WebException: Unable to connect to the remote server] System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6, Int32 timeout) +5482743 System.Net.PooledStream.Activate(Object owningObject, Boolean async, Int32 timeout, GeneralAsyncDelegate asyncCallback) +202 System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback) +21 System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout) +332 System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) +160 System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) +159 System.Net.Mail.SmtpClient.GetConnection() +35 System.Net.Mail.SmtpClient.Send(MailMessage message) +1213[SmtpException: Failure sending mail.] System.Net.Mail.SmtpClient.Send(MailMessage message) +1531 Benefits_Default.Page_Load(Object sender, EventArgs e) in d:My WebsitesBenefitsBenefitsDefault.aspx.cs:36 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927
I got server error when downloading pdf file from my webpage in asp.net."A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond in asp.net."
Code:
protected void btnPdf_Click(object sender, EventArgs e)
{
imgphoto.Src = "http://localhost:51350/Project/imagesLogin/black.png";
string imgurl = Convert.ToString(imgChart.ImageUrl);
imgurl = imgurl.Replace("~", "");
imgChart.ImageUrl = "D:/Project" + imgurl;
Chart1.Visible = false;
[code]....
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 RepliesI am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).
View 7 RepliesIn my application there are 4 connection strings...from that i want one connectionstring should be default connection string.How to do ?
View 1 RepliesI have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
I am preparing for an Access2007 db conversion at the beginning of the year and would like to know what the best process would be for connecting to the sqlserver2005 database. I have read about adding the connection string to the web.config file. I have also read about using ADO.NET and put the connection information into a class and not the web.config file.
I would like to hear from others as to what you have used, are using, or plan on using for a webapp (vs2010), and why so I can get an understanding.
I am new in Asp.net with Oracle and not build proper connection in it.
View 2 RepliesI have an ASP.Net website running on IIS7. The Application Pool is set to ASPv4 Classic.
Authentication Mode is set to ASP.Net Authentication & Windows Authentication
My question is, when I want to connect to SQL using a "trusted connection" in the Connection String, what user will actually be passed into SQL?
I thought it would pass my logon details, but it is coming back with an NT AUTHORITYANONYMOUS LOGON error, which seems to point towards it not passing in my logon.
How can I realize IE is closing in asp.net? I want to do something in sql when the user close the IE by IE close button.
View 2 RepliesI am building a web application with master page. When a user logs in I save the user details in session and use his details to retrieve data from db. I also have a logout button to clear the session and logout from the application.I want to know how the logout functionality like clearing session can be done if user closes the close button of the browser.
View 3 Replies