Steve,
I am not familiar with windows 2000 but I do believe you have to specify a
username and password in your connection to the remote database. Most likely
it tried as an anonymous user. If your windows2000 machine has an event log
you should review the security log and see if it logged what attempts the
remote machine has made. I also believe that even when you specify a
Username/password in your odbc dsn you still need to specify a
username/password when you instantiate a connection to the remote database
in your code.
If you are not developing the code most client software has a configurable
username and password or the option to use a trusted connection.
Last but not least if you are using sql server you also need to give
permissions for your remote machine to the corresponding databases. This is
also done on a username password basis.
Hope this helps,
John Morrison
___________________________________________________
ITtoolbox: Portals for IT Doers and Decision-Makers
http://www.ITtoolbox.com
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
