>Can I connect to SQL Server from a VFP app without having to set up an ODBC datasource on each workstation?

Steve,

Yes, you can do. See sample code below:

lnConn = SQLSTRINGCONNECT( "DRIVER={SQL Server};" + ;
		 "Server=;"+ ;
		 "UID=;" + ;
		 "PWD=;" + ;
		 "DATABASE=;")