Hi,<BR>I am trying to connect to a remote database which is located in New York. Our web server and office location is LA. We would like to give the users a way to dynamically connect to different SQL servers in 200 different cities from their desktop. How can we do this? The IP address, user names, and passwords are kept on the users' system DSN connection string. Is there a way that we can access our client's local machine and reference to that information?<BR><BR>Thanks for reading this message. Hope to hear from you soon.