Yes, you need to make sure that no users are logged into the SQL Server and also make sure that you have the SQLAgent running to run scheduled tasks (this service should be set to Automatic).

To avoid us from continuing to go around and around on this issue, it would greatly help if you could make screenshots of your ODBC configuration screens for this datasource you are attempting to create. I am really at a lost without visually see what all your configurations are, because the error indicates that you are not configuring the ODBC connection correctly.

So, please make screenshots of your WinNT and Win2K ODBC connections and also ODBC connections in the server where you are connecting to either of these servers.
========================================
Buh Bye!

Cheers,
Me