Thank you.. Yes, you are right.
It works fine with SQL2005 express edition on localhost.
It cannot connect to SQL2000 whether it is on local or remote system.
is there anything to be done to connect to SQL2000? i think something is wrong in passing instance name here in these 3 parameters.