WCF / ASMX :: There Is Already An Open DataReader Associated With This Command Needs To Be Closed
Nov 26, 2010
My scenario:I am using a web service which access the sql server database to provide an XML output. this part is working fine. I am using a SqlDataAdapter and DataTable with Fill method to get the data.
Problem:When more than one person access this web service at the same time i get the error message which is given in the subject line.
I understand the problem is because of the sql connection which is still open by the first user. If the first user completes his operation before the second users request then both the user receives the correct response.
My Solution:What i did was i initiated 10 connection strings and will check which connection string is closed and i have used this connection for the second persons request if they both access at the same time.
View 6 Replies
Similar Messages:
Aug 27, 2010
when i insert record ,There is already an open DataReader associated with this Command which must be closed first.
SqlConnection conn = new SqlConnection(@"Data Source=LocalhostSQLEXPRESS;Initial Catalog=StudentDetails;Integrated Security=True"); [code]...
View 6 Replies
May 27, 2010
protected void Page_Load(object sender, EventArgs e)
View 7 Replies
Jul 21, 2010
i am getting this error "There is already open Datareader associated with this command which muct be closed first"
what are the chances of getting this error becoz it giving me so much problem
and how can i solve this error by writing a well code
View 3 Replies
Feb 23, 2010
I am using MS SQL Server 2005 and i added "" to my connection string and i still have the problem
"There is already an open DataReader associated with this Command which must be closed" ;
SqlDataReader dr2;
StrSql = " SELECT * from Modules";
cmd.Connection = conn;
cmd.CommandText = StrSql; [code]....
View 1 Replies
Feb 21, 2011
what are the best way to handle this error
There is already an open DataReader associated with this Command which must be closed first.
i have created my own conneciton class for the same
is there any best way ,is .net manage this things if i use any inbuild class
View 8 Replies
Jul 28, 2010
I am getting an error that an open DataReader associated with this Command, when I'm not using datareader(though probably executereader() is the same thing) how would I close this if I don't have a datareader present?
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
SqlCommand cmd = new SqlCommand("spSelectAllTypes",conn);
cmd.CommandType = CommandType.StoredProcedure;
[code]...
I just want to be able to databind a bunch of dropdownlist in one open connection. (before I had multiple open and closes for each control)
View 2 Replies
Jun 28, 2010
Dim sqlc1 As New SqlCommand("sp_navmenu 275,1,21", ERIKSDbCon)
View 4 Replies
Oct 14, 2010
This error stopping my work in my crucial time. The error is "The underlying connection was closed: The connection was closed unexpectedly.".There are multiple WCF service I created in my project. But when I am requesting only one service this error is coming. I compare with other service, no difference. The service works fine in the morning, but afternoon it stops working and raising error.
I installed Silverlight 3.0 Tools for 2008 Sp1, Silverlight 3.0 Developer, WCF RIA Beta and Silverlight 4.0 runtime in my system in the morning. After getting this error I uninstalled WCF RIA Beta. But same issue.Could not find any solution. Please assist me how to solve this issue.
View 2 Replies
Apr 22, 2010
I've got a static class containing a static field which makes reference to a wrapper object of a DataContext.
The DataContext is basically generated by Visual Studio when we created a dbml file & contains methods for each of the stored procedures we have in the DB.
Our class basically has a bunch of static methods that fire off each of these stored proc methods & then returns an array based on a LINQ query.
Example:
public static TwoFieldBarData[] GetAgesReportData(string pct)
{
return DataContext
.BreakdownOfUsersByAge(Constants.USER_MEDICAL_PROFILE_KEY, pct)
.Select(x => new TwoFieldBarData(x.DisplayName, x.LeftValue, x.RightValue, x.TotalCount))
.ToArray();
}
Every now and then, we get the following error:
There is already an open DataReader associated with this Command which must be closed firs
This is happening intermittently and I'm curious as to what is going on. My guess is that when there's some lag between one method executing and the next one firing, it's locking up the DataContext and throwing the error.
Could this be a case for wrapping each of the DataContext LINQ calls in a lock(){} to obtain exclusivity to that type and ensure other requests are queued?
View 3 Replies
Nov 10, 2010
I have a couple of queries that I need to run one to a linked server and one not like this
Dim InvestorLookup As String = "DECLARE @investor varchar(10), @linkedserver varchar(25), @sql varchar(1000) "
InvestorLookup += "SELECT @investor = '" & investor & "', @linkedserver = '" & db & "', "
InvestorLookup += "@sql = 'SELECT * FROM OPENQUERY(' +@linkedserver + ', ''SELECT * FROM db WHERE investor = ' + @investor + ' '')' EXEC(@sql)"
Dim queryInvestorLookup As SqlCommand = New SqlCommand(InvestorLookup , conn)
Dim BondNoDR As SqlDataReader = queryInvestorLookup.ExecuteReader()
Dim PasswordCheck As String = "DECLARE @investor varchar(10), @password varchar(20), @linkedserver varchar(25), @sql varchar(1000) "
PasswordCheck += "SELECT @investor = '" + investor + "', @password = '" + password + "', @server = '" + db2 + "', "
PasswordCheck += "@sql = 'SELECT * FROM @server WHERE investor = @investor AND password = ' + @password + ' '' EXEC(@sql)"
Dim queryPasswordCheck As SqlCommand = New SqlCommand(PasswordCheck, conn)
Dim PasswordDR As SqlDataReader = queryPasswordCheck.ExecuteReader()
As far as I can tell from debugging the queries both run as they should but I get the error There is already an open DataReader associated with this Command which must be closed first. Is it possible to run two queries in two different DataReaders. I need to later reference each DataReader and select values from each.
View 3 Replies
Dec 25, 2010
why does web services do not support datareader? plz explain it ,it's urgent .
View 3 Replies
Sep 9, 2010
I have Five Web part Zones in my page and each one have Gird control.
I have Five link buttons in same web page.
My requriemnt is when Any webpart is closed, when click on corresponding link must open the corrsponding closed webpart.
View 1 Replies
Apr 14, 2013
In my asp.net +vb+access web i have made a login page and the code is as under
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:webauth.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
con.Open()
Dim cmd As New OleDbCommand("select * from Users where userid =@userid and Password=@password", con)
cmd.Parameters.AddWithValue("@userid", txtUserName.Text)
[Code] ....
I am getting error The connection was not closed. The connection's current state is open.
View 1 Replies
Nov 11, 2010
In Visual Studio 2005 I am following the steps to add a Web Reference to a web service.hings appear to go smoothly except for an error messae I am getting. Here are thesteps I follow along with the result.1. Right click on Web References folder and select "Add Web Reference..."2. When the dialog box appears I add the web service URL into the URL dialog box.The web service methods are then displayed in the dialog box with the links to each web service and a prompt to "Start Browsing for Web Service"However in the box to the right which is labeled "Web services found at this URL", there is an error messagewhich reads:There was an error downloading 'https://stage-serv/weatherQuote/WebService/weatherQuote.asmx
The underlying connection was closed: An unexpected error occurred on asend.Authentication failed because the remote party has closed the transport stream.I don't know what is causing this problem. I can reference this same web service on a productionserver just fine, but if I attempt to access it on the stagig server I get the message Ijust talked about.I am thinking that something is not configured on the staging server correctly.
View 3 Replies
Feb 26, 2011
I have a WCF service which has 4 Operation contracts.
I have added a new contract and it gets the data from database and returns the result set.
I can access the new contract and the service get the correct result set. But while passing the result set to the client I get the error of The underlying connection was closed: The connection was closed unexpectedly.
What are the steps to follow after adding a new contract like new binding etc.
View 3 Replies
Oct 22, 2010
I'm receiving the following error occasionally when calling web service using a .NET 4.0 web application."The underlying connection was closed: An unexpected error occurred on a send."All of the articles I've read regarding this issue are for the Framework 1.1.Is there any solution to this issue for using .NET framework 4.0?
View 1 Replies
Aug 23, 2010
I am consuming a third party web service wsdl using my .net aps.net page. And I am getting following error message. Cannt get to resolve it. Its working on my machine but not in my development machine. I have installed the certificate also in certificates on that machine.
Error --> The underlying connection was closed: An unexpected error occurred on a send.
View 3 Replies
Nov 15, 2010
I'm having a method that exports content from the database to excel files. The method taks as paramaters a DataReader param and a int param - the number of rows. For the number of rows i'm using a dataset, wich i fill using the same query as for the datareader. So I'm executing it twice... Is there a way I can avoid that? get the number of rows from the datareader?
View 1 Replies
Mar 8, 2011
inside row command event of gridview i want to call a function which will open db conectn and run a stored proc to fetch value.but this gives error.
View 3 Replies
Sep 3, 2010
I need to open a Command prompt (cmd.exe) of a Remote server computer and Run a Command from my asp.net web application (C# laungauge). I have progressed till opening a command prompt of the webserver where the website is hosted. My code is:
[Code]....
I have achived this using the VB script. The code is:
[Code]....
In the above code psexec.exe is software used to access remote computers.nawinapp627 = Remote serverPlease help me to achieve above using C#.
View 13 Replies
Sep 13, 2010
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.
View 3 Replies
Feb 3, 2011
I have created a webservice in 2010. And when I call it from my web application sometimes,It generates the follwoing errors:-1. The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.2. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have already tried increasing excutonTimeOut etc.
View 2 Replies
Mar 9, 2011
I am not sure whether I posted the question at the right place, But I don know how to start approaching the problem ,
I need to open a .cer cirtificate from the server side. The .cer cirtificate will be stored in the client browser.
I tried locally putting the cirtificate in my hard drive and I could open it and get the info I want using
X509Certificate2 certificate = new X509Certificate2("C:\OCX\abc.cer");
But what will I do when I need it to open it from client browser?
View 13 Replies
Nov 19, 2010
I have my wcf service and it runs fine. Then from my asp.net application I am trying to connect to this service. Everything is ok, request from asp.net is received in service (as I can debug code) and then when it returns to client I have the following error:underlying connection was closed: The connection was closed unexpectedlyMy contract on WCF service is as follows:
[OperationContract()]
WCFResponseGetAllProducts GetAllProducts(WCFRequestGetAllProducts request);
And WCFResponseGetAllProducts , WCFRequestGetAllProducts classes have [DataContract] attributes. Members of those classes have [DataMember] attribute. However when I added another method to my contract:
[OperationContract()]
int Test();
then I can execute it from asp.net mvc application without a problem.
PS. I host my wcf service in default web server in visual studio 2010 at the moment
View 3 Replies
