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.

View 2 Replies


Similar Messages:

Databases :: Oracle Database Failover Not Working With Pooled Connections?

Feb 22, 2010

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.

View 1 Replies

DataSource Controls :: Connections Are Being Pooled Even With "Pooling=False"?

Jan 27, 2010

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.

View 8 Replies

WCF / ASMX :: Web Service Fails - 400 Bad Request - Only Certain Connections

Feb 21, 2011

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.

View 1 Replies

Security :: Request QueryString - Change In Id Opens Other Page?

Jan 20, 2010

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?

View 2 Replies

Server Does Not Support Secure Connections

Mar 16, 2010

I get this error on line 39 -"Server does not support secure connections.".

[Code]....

View 5 Replies

SQL Server :: Connections Of External Mdf Files

Aug 12, 2010

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)

View 6 Replies

AJAX :: ValidatorCalloutExtender - Opens As Popup

Feb 21, 2011

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.

[Code]....

View 1 Replies

AJAX :: Drag Panel Position When It Opens?

Apr 14, 2010

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.

View 1 Replies

AJAX :: Get XML Data From Server On Request?

Dec 13, 2010

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?

View 2 Replies

AJAX :: Pane Should Open When Child Pages Opens?

Sep 17, 2010

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

<cc1:Accordion ID="MyAccordion" runat="Server" SelectedIndex="-1" HeaderCssClass="accordionHeader" HeaderSelectedCssClass="accordionHeaderSelected" ContentCssClass="accordionContent" AutoSize="None" FadeTransitions="true" TransitionDuration="250" FramesPerSecond="40"
RequireOpenedPane="false" SuppressHeaderPostbacks="true">
<Panes>
<cc1:AccordionPane ID="AccordionPane4" runat="server">
<Header>Test Assignment</Header>
<Content>
<ul>
<li><a href= "AssignAssociate.aspx">Assign Associate</a></li>
<li><a href= "DeleteAssociate.aspx">Delete Associate</a></li>
<li><a href= "Reports1.aspx">View Reports</a></li>
</ul>
</Content>
</cc1:AccordionPane>
</Panes>
</cc1:Accordion>

View 4 Replies

AJAX :: ISA Proxy Server Returning 407 For Request?

Feb 10, 2010

We are using 2 ISA proxy servers in front of our webserver and are getting intermittant Ajax errors in our application.

Our web logs indicate that there are 407 errors occurring during the requests.

When other users hit the webserver directly this issue does not occurr and this is also not an issue in IE8 but is in IE7.

The error dialog has Sys.WebForms.PageRequestManagerParserErrorException and the details say "error parsing near '<!DOCTYPE html P'

View 1 Replies

DataSource Controls :: Server Profiler / ReportServer Has Four Connections After Restart?

Jan 22, 2010

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;

Audit Logout
RPC:Completed
Audit Login
RPC:Completed
RPC:Completed
SQL: BatchStarting
SQL: BatchCompleted
SQL: BatchStarting
SQL: BatchCompleted

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?

View 1 Replies

Visual Studio :: Using Server Explorer In 2005 And Database Connections?

Mar 27, 2010

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 ?

View 3 Replies

DataSource Controls :: Verify That SQL Server Is Configured To Allow Remote Connections?

Dec 8, 2010

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).

View 2 Replies

DataSource Controls :: Verify That SQL Server Is Configured To Allow Remote Connections?

Jun 11, 2010

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).

View 2 Replies

Ajax - Is It Possible To Use XMLHTTP Request To Bind Server Controls

Jan 22, 2011

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

View 1 Replies

AJAX :: Request Doesn't Go To Server When Button Click?

Mar 31, 2010

[Code]....

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

View 9 Replies

WCF / ASMX :: Server Does Not Support Secure Connections Error Sending Mail?

May 12, 2010

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

View 2 Replies

AJAX :: Mouse Focus Stays On Background When Modal Popup Opens

Dec 17, 2010

The title of this post says almost all.

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.

View 3 Replies

AJAX :: Is It Possible To Make Request And Simulate The Server Response In The Code Behind

Mar 4, 2010

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 ?

View 2 Replies

AJAX :: Error: Sys.WebForms.PageRequestManagerTimeoutException: The Server Request Timed Out?

Feb 17, 2010

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,

http://forums.asp.net/p/1042916/2700600.aspx#2700600

http://forums.asp.net/p/1042916/3582830.aspx#3582830

http://forums.asp.net/p/1189929/2040856.aspx#2040856

http://forums.asp.net/p/1355876/2781123.aspx#2781123

View 4 Replies

AJAX :: Window.Open In AJAX Accordion Panel Opens Link In Same Window

Aug 31, 2010

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.

[Code]....

View 2 Replies

C# - How To Make AJAX Request To The Server Without Getting Response With The Information For All The Update Panels

Jan 12, 2010

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?

View 1 Replies

AJAX :: AsyncFileUpload - Server Response Error - Maximum Request Length Exceeded

May 6, 2010

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?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved