I am developing in SQL Server 2000, and connect via a DSN,

I have two servers registered on my PC, one being the central one, and one being local.

my DSN is set to look at a database on the central server, however, from time to time it seems to reset itself to look at the database on my local server (both are called the same thing)

Can anyone tell me why this is happening, and how do I stop it

Many thanks