We have a problem on one of our databases: sporadically all XP machines remotelly connected to that database -which is the haviest one- all of them are dropped and at the next request the egt an error:"[DBNETLIB]general network error", it does not happen to win 98 machines or to clients connecting to other databases on the same Mssql server. I have a feeling that it is Mssql connectivity installed that is cauing it but I do not see any option to uninstall it.
ok - most importantly understand i am not an expert on this issue. Check everything
I have transferred my application back to an sql 7.0 server and everything is working 100%... also works 100% on SQL 2000 with mdac 2.5
... im not sure how to get mdac version... there is a SELECT @@version command in sql - but i dont know if it returns mdac...
Im using asp and I simply did a conn.version statement.... and as its the connection that seems to be causing the problems I reccommend you get the properties from the connection. Im not sure if the iis or the sql server mdac is returned... tho some say different mdac versions on the two can cause problems.
I cant be 100% that this is your problem... but everywhere i look im finding people having trouble with sql 2k sp3 mdac 2.8
In the registry, under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess,
there are string values called FullInstallVer and Version. One or both contain the MDAC version number; not sure what the difference is. My machine has the same value for both (2.80.1022.3).