I want to access SQL Server data on a webserver from a local VFP app. Can we connect to the SQL Server database without having a local ODBC connection setup to the database? In other words, we want to create the connection in the code rather than having each user create a local DSN?

Thanks,
Doug