Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-18 : 08:33:27
|
| samir patel writes "Res. Sir,i want to ask one question that sql server disconnect automatical. so what is the solution to it to be continue ever.i understand briefly i have vb 6.0 ,crystal report and win xp and SQl server 2000. if i want to see perticular report and i get it but after some time it will give me error of disconnection with server. what is the solution. and if i agin restart it will give me report but after some time it will not..so , i kindly requet to give reply soonsamir patel. " |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-18 : 09:55:04
|
| Check ur network for possible problemsAlso check for virusesIN SQL server there is nothing as such connecting - disconnecting in its own as per my knowledge |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-19 : 02:14:50
|
| Do you need to open the connection before the "task", do the task, then close the connection? If you just open the connection once, and leave it open within your application, maybe it is timing out?Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-19 : 08:10:38
|
| It sounds connection time out problem as Kristen said.MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
About MS SQL Server 2000