>just last saturday i was fine connecting foxpro and java to SQLSERVER 2000
>
>the connection was broken this monday and cannot reconnect anymore
>because of missing VNSAPI32.DLL
>search our network for this file but cannot find it.
>sqlserver agent is stopped. services is stopped
>please help if anybody has any idea what is going on.

This DLL is used by Banyan VINES Network. Are you using that kind of network?