<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Programming
»
Connecting
»
SQL Connection getting dropped
15 posts, Page 1 of 2
1
2
»»
SQL Connection getting dropped
Rate Topic
Display Mode
Topic Options
Author
Message
BeerBeerBeer
BeerBeerBeer
Posted Sunday, July 31, 2011 4:51 PM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239,
Visits: 68
I have a situation with one of our clients where one of our utility applications is losing it's SQL connection after it has successfully retrieved data.
For instance, the customer can log into the application, load a list of members, but on trying to view an individual members details we'll get the following exception
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
The Connection String uses an IP address to get to the server - don't know if this makes behaviour any different - I would doubt it though.
Have tried it with pooling=false but no difference.
Have elongated the server time out setting to no avail.
We have multiple clients connection to the DB server in this fashion but only some of them are experiencing this behaviour.
At this point, at a loss as to where to look next - hopefully someone has some fresh ideas about what might be happening - or can ask some questions that might open up those ideas
TIA
Steve
Regards,
Steve
Life without beer is no life at all
All beer is good, some beers are just better than others
Post #1151564
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, August 01, 2011 5:17 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357,
Visits: 9,530
Are those users connected on a db with log-shipping?
Do you kill connection to resolve blocking?
Do you reboot the server (or service) on a regular basis?
Post #1151702
BeerBeerBeer
BeerBeerBeer
Posted Monday, August 01, 2011 7:35 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239,
Visits: 68
Ninja's_RGR'us (8/1/2011)
Are those users connected on a db with log-shipping?
No
Do you kill connection to resolve blocking?
No
Do you reboot the server (or service) on a regular basis?
No
If I can work my way down this list
There is no log shipping - effectively there is no real DBA in control. You'd have to live outside a large country to understand the small systems we work with (actually, they're large to us ... )
The connection is getting killed during processing of a query - no need for us to kill it. No, the application does not kill the connection (though I will review this)
If you have to reboot your server, you're doing it wrong in the first place. But the direct answer is No.
Appreciate your questions, hope my answers lead to more
Regards
Steve
Regards,
Steve
Life without beer is no life at all
All beer is good, some beers are just better than others
Post #1151796
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, August 01, 2011 7:38 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357,
Visits: 9,530
I've never seen anything else that could explain this... will hang around just in case.
Post #1151800
BeerBeerBeer
BeerBeerBeer
Posted Monday, August 01, 2011 7:52 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239,
Visits: 68
I agree.
Very weird
The fact that the connection happens and data is retrieved, THEN the connection is lost ???
We have other environments where this utility is running without any issue whatsoever.
One last piece of information (which shouldn't make any difference) is that the DB is sitting behind a Terminal Server environment for the actual application. We are connecting direct to the SQL Server instance with our connection string for this utility app, ignoring the TS setup.
Don't know if that makes a difference - again suspect not.
Again, thanks for questions, suggestions, ideas.
Steve
Regards,
Steve
Life without beer is no life at all
All beer is good, some beers are just better than others
Post #1151806
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, August 01, 2011 7:54 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357,
Visits: 9,530
Are you using nolock hints or read uncommitted?
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Post #1151810
BeerBeerBeer
BeerBeerBeer
Posted Monday, August 01, 2011 7:58 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239,
Visits: 68
There are no hints in the DB queries and we do not suggest how the lock should be - basically we trust SQL Server
Regards,
Steve
Life without beer is no life at all
All beer is good, some beers are just better than others
Post #1151811
Ninja's_RGR'us
Ninja's_RGR'us
Posted Monday, August 01, 2011 7:58 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 5:19 AM
Points: 21,357,
Visits: 9,530
Ninja's_RGR'us (8/1/2011)
I've never seen anything else that could explain this... will hang around just in case.
Post #1151812
BeerBeerBeer
BeerBeerBeer
Posted Monday, August 01, 2011 8:02 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, March 26, 2012 7:17 PM
Points: 239,
Visits: 68
I do believe that is a similar face to mine once I was told this was happening ...
Regards,
Steve
Life without beer is no life at all
All beer is good, some beers are just better than others
Post #1151816
ALZDBA
ALZDBA
Posted Monday, August 01, 2011 8:04 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861,
Visits: 8,045
is there a query exception recorded in e.g. errorlog ( deadlock / error with Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered, the client connection is terminated after receiving the message, and the error is logged in the error and application logs.)
Johan
Jul 13
Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere
-
How to post Performance Problems
-
How to post data/code to get the best help
-
How to prevent a sore throat after hours of presenting ppt ?
"press F1 for solution", "press
shift
+F1 for urgent solution"
Need a bit of Powershell? How about
this
Who am I ?
Sometimes this is me
but
most of the time this is me
Post #1151817
« Prev Topic
|
Next Topic »
15 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
