Yeah I can ping the sql server from the trouble machines. And yes the latest version of MDAC is installed becuase they some of them are running XP, which comes with mdac 2.7.

I am going to install mdac 2.7 on the 2000 machines and see if the works but i doubt it.


Eric