I'm trying to set up a connection to SQLServer2000 within a VFP 7 database, but I'd like to do it without having to manually set up an ODBC connection on each users' machine first.

I want each user to be able to use their own UID and password from the windows login so they don't have to do it again when it logs into SQL Server.

Is there a way to do this? (Most users have Windows XP or Windows 2000)

Thanks in advance for any advice.

Mike