Well I updated MDAC 2.7 on one of the 2000 machines and it worked. But the funny thing is that the XP clients cant see the server. I dont think this is a mdac problem anymore. I wonder if I use the ip of the sql server instead of the name in the connection string?