Click here to Skip to main content
15,920,102 members
Home / Discussions / Database
   

Database

 
GeneralRe: My table have to be like this Pin
Ashfield18-Jul-08 5:21
Ashfield18-Jul-08 5:21 
GeneralRe: My table have to be like this Pin
Alsvha18-Jul-08 9:03
Alsvha18-Jul-08 9:03 
GeneralRe: My table have to be like this Pin
Paul Conrad18-Jul-08 9:07
professionalPaul Conrad18-Jul-08 9:07 
QuestionAvoiding #Error in Microsoft Access 2007 Pin
fifothekid17-Jul-08 22:18
fifothekid17-Jul-08 22:18 
QuestionAn error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl17-Jul-08 21:55
dasha_pl17-Jul-08 21:55 
AnswerRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius18-Jul-08 5:29
mentorWendelius18-Jul-08 5:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 6:54
dasha_pl21-Jul-08 6:54 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius21-Jul-08 8:29
mentorWendelius21-Jul-08 8:29 
Hmm,

What you could try is (modify only one thing at once and if nothing is changed, return to original configuration):
- add connection timeout-parameter to connection string ("Connection Timeout=60") The default id 15 seconds.
If the server is running low on resources, it may be unable to give you a connection in 15 seconds.
- increase packet size by adding "Packet Size=16384". Default is 8192.
This way the server doesn't need to send so many packets especially when large amount of data is to be sended
- Try disabling connection pooling by adding "Pooling=false" to your connection string. Default is true.
This will eliminate possible aging problems in pool

if possible at database server side you should check:
- start the query and check in database, how your connection is doing.
This can be done by using Management studio or sp_who stored procedure. You should see your connection in "runnable" state
- check the error logs for sql server. When the query is returning you an error, is anything recorded in error log

And of course you could try to run the select statement using 'normal' SqlCommand class along with data reader without LINQ. Just to make sure that LINQ isn't causing any problems.

I'm sorry that I cannot be more specific, but the problem isn't the easiest one to solve.

If you find out anything, please post your findings


Mika
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 20:27
dasha_pl21-Jul-08 20:27 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 1:52
dasha_pl22-Jul-08 1:52 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius22-Jul-08 5:33
mentorWendelius22-Jul-08 5:33 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 21:44
dasha_pl22-Jul-08 21:44 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius23-Jul-08 5:48
mentorWendelius23-Jul-08 5:48 
QuestionExcel Query [modified] Pin
Sunil Wise17-Jul-08 21:01
professionalSunil Wise17-Jul-08 21:01 
AnswerRe: Excel Query [modified] Pin
Sunil Wise17-Jul-08 21:32
professionalSunil Wise17-Jul-08 21:32 
QuestionHow to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8717-Jul-08 4:22
guriqbal8717-Jul-08 4:22 
AnswerRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
leoinfo17-Jul-08 5:17
leoinfo17-Jul-08 5:17 
GeneralRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8720-Jul-08 20:50
guriqbal8720-Jul-08 20:50 
AnswerCross Post Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionSending Email Pin
jonhbt17-Jul-08 3:38
jonhbt17-Jul-08 3:38 
AnswerRe: Sending Email Pin
Wendelius17-Jul-08 8:06
mentorWendelius17-Jul-08 8:06 
QuestionNested Cursor loop problem Pin
Member 387988117-Jul-08 3:25
Member 387988117-Jul-08 3:25 
AnswerRe: Nested Cursor loop problem Pin
Mark J. Miller17-Jul-08 9:27
Mark J. Miller17-Jul-08 9:27 
GeneralRe: Nested Cursor loop problem [modified] Pin
Member 387988117-Jul-08 19:59
Member 387988117-Jul-08 19:59 
GeneralRe: Nested Cursor loop problem Pin
Mark J. Miller18-Jul-08 5:20
Mark J. Miller18-Jul-08 5:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.