No announcements
Found 3529169 threads
-
2 Votesreaders blocking writers
You can observe readers-block-writers simply by adding a "WITH (HOLDLOCK)" hint to the SELECT but that is effectively like changing the isolation ...Answered | 4 Replies | 6350 Views | Created by Manu_vmr - Sunday, May 6, 2012 10:53 AM | Last reply by Dan Guzman - Sunday, May 6, 2012 12:56 PM
-
0 Votes
invalid attempt to fieldcount when reader is closed + ExecuteDataSet
One more thing check sql server is running before esbalishing a connection to it.Answered | 2 Replies | 6058 Views | Created by Srinivas Akella - Tuesday, July 6, 2010 6:10 PM | Last reply by razyee - Thursday, July 15, 2010 6:11 AM -
5 Votes
Close Connections
Close closes the connection, but allows you reuse the same connection instance later by calling Open.Answered | 14 Replies | 2857 Views | Created by obrienkev - Friday, May 21, 2010 11:54 AM | Last reply by obrienkev - Thursday, May 27, 2010 10:55 AM -
0 Votes
Distribution cleanup is blocking log reader
Can you shut down the log reader for a while?Answered | 5 Replies | 4171 Views | Created by MarkAllison - Wednesday, April 19, 2017 2:11 PM | Last reply by MarkAllison - Wednesday, April 26, 2017 9:36 AM -
0 Votes
Muliple SQL connection in using block
A using{} block is preferable.Answered | 7 Replies | 998 Views | Created by Athulya Pillai - Friday, August 12, 2016 12:32 PM | Last reply by William Xifaras - Wednesday, August 24, 2016 6:25 PM -
0 Votes
to close connection to database after i use or not ?
Make sure you close the connection and then dispose the connection object; Good luckAnswered | 4 Replies | 3211 Views | Created by E_gold - Monday, March 28, 2011 7:14 PM | Last reply by Hamid Jabarpourfard - Tuesday, March 29, 2011 5:17 AM -
0 Votes
to close or not to close connection in databse
Therefore, you must explicitly close the connection by calling Close or Dispose methods.Answered | 3 Replies | 3835 Views | Created by E_gold - Thursday, February 10, 2011 8:03 PM | Last reply by Paras Sanghani - Friday, February 11, 2011 6:13 AM -
2 Votes
Re-Throwing Exceptions and using a Finally block
you can have the finally block which will close the connection and in the catch block you can create and throw your own exception.Answered | 6 Replies | 10032 Views | Created by remarkpk11 - Tuesday, May 5, 2009 6:23 PM | Last reply by A.m.a.L Hashim - Tuesday, May 5, 2009 8:46 PM -
0 Votes
Invalid attempt to call Read when reader is closed
The calling function must close the reader which in turn would close the connection.Answered | 1 Replies | 5366 Views | Created by Karthizen - Sunday, January 3, 2010 6:25 PM | Last reply by Haripraghash - Monday, January 4, 2010 6:37 AM -
0 Votes
return data reader value
Additionally don't close your connection in the Try Block, add a finally block and close it there since if you have an exception thrown in your ...Answered | 2 Replies | 3136 Views | Created by devpan - Thursday, May 27, 2010 8:23 AM | Last reply by Cor Ligthert - Thursday, May 27, 2010 9:28 AM -
1 Votes
Need to close connection when using DatabaseFactory.LoadDataSet?
And if you don't have sources then you should consider using Reflector.Answered | 1 Replies | 3499 Views | Created by SteveOrderUpHQ - Sunday, March 28, 2010 11:54 PM | Last reply by Miha Markic - Monday, March 29, 2010 6:22 AM -
3 Votes
Open a PDF document in adobe print it and close adobe reader using VB.NET
In the Add Reference dialog, I browsed to the "C:\Program Files (x86)\Adobe\Reader 10.0\Reader" directory ...and double-clicked on the largest dll ...Answered | 7 Replies | 12052 Views | Created by renni_e - Friday, October 28, 2011 4:53 PM | Last reply by JohnWein - Wednesday, November 2, 2011 8:56 PM -
0 Votes
TCPServer decting connection close
The server itself is a single threaded, so I use the blocking function networkStream.read(...)Answered | 1 Replies | 3819 Views | Created by jaya90 - Monday, January 3, 2011 3:30 PM | Last reply by NagarjunaDilip - Tuesday, January 4, 2011 4:38 AM -
0 Votes
Database connections not closing
(in 1.1 that did not exist that is why it was not in there to start) The Using block was in C# since early 2001 which is .NET 1.0 so if your code is in C# who ever wrote the ...Answered | 6 Replies | 4299 Views | Created by YuJie - Thursday, June 12, 2008 6:20 PM | Last reply by YuJie - Friday, June 13, 2008 6:08 PM -
0 Votes
close reader or connection in USING block
Firstly, as mgebhard said, please call the Close method when you have finished using the DataReader object.Answered | 2 Replies | 205 Views | Created by Anonymous - Sunday, July 26, 2015 4:36 AM | Last reply by Anonymous - Tuesday, July 28, 2015 4:30 AM -
1 Votes
Clearing resources after using a stream reader?
For example FileStream, Web Response contains a close method where as the WebRequest class would not.Answered | 2 Replies | 2904 Views | Created by Ambious - Tuesday, April 20, 2010 2:37 PM | Last reply by Praneeth Wickramasinghe - Tuesday, April 20, 2010 2:49 PM -
1 Votes
Dispose vs close of sql connection.
Close() - returns the inner connection to the connection pool (or disposes it if there is no connection pool) Dispose() - calls the ...Answered | 4 Replies | 16737 Views | Created by rajemessage - Friday, April 23, 2010 4:34 PM | Last reply by DCChalk - Thursday, April 29, 2010 11:08 AM -
0 Votes
Invalid attempt to call Read when reader is closed.
You will have a better chance of getting a fast answer in the ADO.NET specific ...Answered | 2 Replies | 12441 Views | Created by Gaurab Chatterjee - Monday, February 23, 2009 7:06 AM | Last reply by Kaps Pune - Tuesday, February 24, 2009 9:54 AM -
1 Votes
sqldatareader error “Invalid attempt to call Read when reader is closed.”
http://stackoverflow.com/questions/4912782/i-keep-getting-this-error-invalid-attempt-to-call-read-when-reader-is-closed Thanks Md.Answered | 3 Replies | 11969 Views | Created by simon69 - Thursday, November 1, 2012 11:27 PM | Last reply by Md. Marufuzzaman - Sunday, November 4, 2012 5:55 AM -
1 Votes
StreamReader.ReadLine() blocks !
the problems of blocking actually is not an issue, neither a bug, i am using a TCP connection, if end of stream is not encountered (which means the lost ...Answered | 16 Replies | 10261 Views | Created by Abinonos - Tuesday, May 14, 2013 4:50 PM | Last reply by Abinonos - Thursday, May 16, 2013 12:56 PM - Items 1 to 20 of 3529169 Next ›
No announcements
