Very Computer

Can anyone explain why this is happening more? We are using MDAC 2.6

Thanks

Did you upgrade the clients as well?  What net-lib and version of odbc/ole-db
do you have on the clients?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

Is your problem where you have a screnful of data in Access or Ent Manager
and the data disappears to conserve server resources, then when you refresh
you get a message saying "communications link failure"

This happened to us, checking the options for Boost priority and NT fibers
on the processor tab of the server properties revealed these had become set
in the upgrade process where in fact the server is a single processor
machine. These options appear to be only recommended for multi-processor
machines. Try changing these settings then stopping and restarting the
server

Alastair Ramsay

Quote:> Can anyone explain why this is happening more? We are using MDAC 2.6

> Thanks

7.00.623
8.0.194

Well you still have the 7.0 net-libs, so try installing the SQL 2000 ones.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq