Ajax Request To SQL Server Opens Too Many Pooled Connections?
Aug 27, 2010
I'm implementing a Google like search box in my asp.net application. Each keypress in the box sends an Ajax request to IIS webmethod that queries the txt and return matches - works pretty cool. However, on loading up activity (e.g. 300 users), I'm getting errors that my 100 Pooled connections are used up. Now I'm rethinking that perhaps opening/closing a db connection on each keystroke may be too much. How would one architect this differently, or insure that the connections are reclaimed really fast. I'm have the 'using' construct for connections to insure it is closed. The concern is GC may not be reclaiming them fast enough?
How would google handle such a large open/close cycle.
We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:
Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: 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. at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.
Recently I bumped a problem with an asp.net application where seemingly random errors were thrown, although they were all related to the use of a connection object. Coming from Classic ASP, I wrote my pages by creating a connection object at the top of the page, and using that connection throughout the page. The connection object was opened whenever something had to be done with the database and closed immediately after.
Connectionstring: "Data Source=<server>;Initial Catalog=<catalog>;Integrated Security=false;user=<user>;password=<password>;Pooling=False;" So pooling=false.
I've got a web service on a server with valid IP and valid DNS entries. I'm using an asynchronous thread in a WPF .NET application to access methods from that web service. Under normal connection conditions, for almost all users, the connection and method works fine. Under a very specific condition - Verizon Aircard being used to connect, no VPN connection to the company through SSTP, on a PC with Forefront Client Security installed - the web service will return a "HTTP Error 400: Bad Request" error to the user. If the same user on the same PC connect their VPN connection, the method works flawlessly.
I have completd my project, in that project i used Request.QueryString["id"], its working fine, in this project if change the "id" securities pages also opening now what can i do?
I have a problem with the connection of external files - northwind.MDF Connection to SQL Server is fine. But to connect to external files wrong. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Intance Specified)
i have a web form in which there are some textboxes, comboboxes, etc... comboboxes is inside an updatepanel. i am adding, deleting and updating these comboboxes with an modalpopupextender. Everything works until i placed the validatorcalloutextenders to check if it is empty. Then the ajaxmodalpopuupextender opens as popup but then i can do anything on the modalpopup. if i open the modal popup with all the required fieldvalidators filled then my modalpopup works.
I am a designer prototyping applications. At the moment I want to show in my prototype that a drag panel opens and it belongs to a tab.
Two questions: How can I make a drag panel belong to a tab?
Should that be too complicated code wise (i am a designer - not a developer...): Can I position the drag panel on opening for the first time?So far, my drag panel always opens in the top left corner in my browser. I tried positioning it with CSS but it just ignores that.
I am in a situation where I need to get XML string of each product from server side on request, but only those tags that are added to XML at server side after the last client request. How can I determine at server side and return only newly added tags of XML of requested product to client so that only latest and relevant information could be shown at client side. And is there any way to save and keep on updating that XML data retrieved for each product on client side?
I have a Accordion control which is having 3 panes but I am getting a collpsing problem when I click on Assign Associate link. I want to open the pane if I click on any of the child controls (Assign /Delete/ View Reports). I have provided similar code for my other two panes it is working as expected. what to change to make the pane in open mode if I click any of the child panes
I think I have a problem that I never noticed before. I was just recently (as in tonight) shown the SQL Server Profiler. I noticed that on a video that I watched there profiler did not move unless there was a query to the database, thus making it easy to see what exactly was going on. When I opened mine for the first time and ran it I am getting 9 logs every say 5 seconds. They consist of;
Does anyone know if this is normal or my database just working way to hard?
I just restarted the server and checked databases for active connections now that I know nothing is running, and found the one database that is causing the problem... ReportServer has 4 connections after my restart. Should I leave this alone? Is it normal to have this reporting constantly going on?
I noticed that when I download a framework say like "Coolite" and open the solution, and find the Connection to the Database showed up in the Server Explorer.
In some other times, the Connection Dose not show.
I can create a connection to a Database in Server Exploere, but I need say to add it to my Web.Config directly, but not sure how. I am trying to drag-and-drop from the Server Explorer to Web.Config, it is not working.
When and how the Connections to Databases will show in Server Explorer ?
How I can create a connection to a Database using say a Wizard, and add it directly to Web.Config ?
I am trying to make a small utility program to update a table in a database.
I made it as a asp.net 2008 project and connected to the development SQL server(which is located locally).It is working fine.
Then I try to move this to production, I realized that the sql server is located in another state and I can not connect it this way.( connection string from webconfig and open the connection).I can not change any configuration of the prod sqlserver.
I get error like sql server does not accept remote connection.( Verify that SQL Server is configured to allow remote connections).
I am trying to make a small utility program to update a table in a database.
I made it as a asp.net 2008 project and connected to the development SQL server(which is located locally).It is working fine.
Then I try to move this to production, I realized that the sql server is located in another state and I can not connect it this way.( connection string from webconfig and open the connection).I can not change any configuration of the prod sqlserver.
I get error like sql server does not accept remote connection.( Verify that SQL Server is configured to allow remote connections).
i only found websites that uses the XMLHTTP request to call an aspx page or what ever page ( make a request to a page that appears the piece of data in a div or so )but i have a question is it possible to use it to bind asp.net server controls Examples 1- bind a gridview or datalist from this XMLHTTP request 2- after click an edit button in a grid can i use XMLHTTP request to fill some text boxes and dropdowns and other asp.net server controls 3- can i use upload files using XMLHTTP request i want to know if this is possible or not because Ajax and update panels are very slow and affect the server and client performance is there another alternative if my senarios are imposible with XMLHTTP request where can i learn about this alternative if this possible where can i learn more about this XMLHTTP request with asp.net server side controls instead of ajax and updatepanel
from above code i use UpdatePanel but when i am click on Button the request doesn't goto server but i want to send request to server.. how can i do that
Server does not support secure connections. at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) atSystem.Net.Mail.SmtpClient.GetConnection() at System.Net.Mail.SmtpClient.Send(MailMessage message) at MailWebService.SendMail(String fromAddress, String toAddress, String subject, String body)I am using a web service to send my mail and I get this error when smtp.EnableSsl = true;If I change it to false it works
This happens only sometimes on the same code, but when I open a modal popup window, mouse focus stays on the background and buttons on the modal popup does not response.
If I move the mousepointer, I can see that buttons on the background are highlighted by mouseover, and I can even click on them.
I have tried to find when this happens by trying different mouse movement without luck.
Does any one have the same experience? I would like to know why this happens and/or how I can pretend this behavior.
i'm just getting started with asp.net and ajax. My question is : is it possible to make an ajax request and simulate the server response in the code behind. in other words can the request be sent to the code behind of the same page? if it's possible haw can i perform this ?
I am getting this ajax timeout error.I am using updatepanel and update progress. Locally am not getting this error but after hosting this error is coming and the page is not navigating to the next page to show the result.
I tried most of the solutions eplained like below,
I'm using the following span to open a page in a new window. What is INCREDIBLY odd is that it is exactly the same code from three different pages, but the first refuses to open in a new window. The only difference is that the first example resides within an Ajax Accordian Panel so I suspect that it might be an Ajax related issue.
For example, I have three UpdatePanels on the page. I click a button, and I get pretty long response, that contains all the data for the three UpdatePanels, the viewstate string.
I want to optimize my query and receive response like "ok" or "not ok". How can I do that?
When the user tries to upload a file with a size more than 4 MB, the AsyncFileUpload control gives a Confirmation alert (with "OK"/"Cancel" button) with the following message "Server Response error: Maximum Request Lengh Exceeded". But when the User clicks the "OK" button a new window popups and shows the server error and on clicking the cancel button the AsyncFileUpload background color turns red. Here I am not sure why the control is showing a Confirmation alert instead of a simple alert message. Is it possible to change the Confirmation alert with the simple alert message? Basically I don't want the popup window to show the server error as it is happening currently. Also, is there a better way to handle the file size error and show apporiate error message to the users?
