>Umm, no. OLE DB providers have absolutely nothing to do with ODBC. ODBC doesn't even know OLE DB exists. OLE DB providers are for use with OLE DB (which you can't directly use with late-binding clients such as VFP 6) and ADO.


Thanks, after doing some MSDN digging I found a graph exactly showing how data moves through layers via OLEDB vs ODBC. I always thought OLEDB was an abstraction layer over ODBC. Consider me now schooled. :)



Thanks again for the info. I will play around with this, since there is a definite bug in the VFP ODBC driver. When using a the Brio ODBC reporting tool, I specify VFP as my ODBC provider and point to a .DBC on a remote network share point; the ODBC driver gets the command to SQL-create tables, but it first generates .tmp files on the Brio server and then tries to reference (rename?) them on the remote machine - it can't find the tables because they never make it to the remote machine. Hopefully the OLEDB driver will behave better.

BTW, since you've read this far, how soon do you think we'll see some VFP-MSSQL2000 samples like those shown at http://msdn.microsoft.com/library/psdk/sql/samples_ie5x.htm ?

Thanks.