Client diconnecting from SQL7 server

[hdeassis]

Hello!

I need your help guys. Here is the scenario,

I have:

1)SQL7 sp4
2)clients are running WIN2K pro.
3)Document management called DM5/docsopen.

The problem that I'm having is that users intermittently disconnect from the SQL server. They are unable to save their documents nor open them. They only way I get around this is to logoff/on and then I'm back in business.

Any ideas? could it be a driver issue. They are using the sql7 client.

Thanks for all your help.

H

 

[SQLBill]

I don't use SQL 7, but you might want to check Timeout settings. I believe that if you make a connection to SQL Server it expects you to pretty much continuously use the connection. So, if you connect, grab your document and then spend time making changes before saving...that time spent making changes isn't 'recorded' by SQL Server as an active connection and it times out.

Possible solutions if this is the issue:
1. Change the timeout
2. Design/redesign the application so that a 'save' automatically reconnects.

-SQLBill

 

[aalmeida]

also check your code for return(@Value) in exeption of query analizer all other programs will se the return() and the close the connection even if the return() is just a status checking.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"