> What is the most recommended way to connect to SQL Server for SQL-Passthrough using dsnless connections to the new oledb provider? Or can the oledb provider be used by sql-passthrough?
If you're referring to the VFP provider, I believe there is some confusion here. The VFP provider gives you connectivity only to VFP data, and has nothing to do with getting to SQL Server data. Think of OLE DB providers as "updated" ODBC drivers, only they use OLE DB/ADO instead of ODBC data access technology.
Mike Stewart