>>>Hello,
>>>i would known how i can use oledb
>>>from vfp6. How i can create a connection
>>>with CREATE CONNECTION
>>>by oledb
>>>
>>>
>>>thanks
>>
>>Use ADO. OLEDB is a very low level access and really is for C applications. ADO is the mechanism for the rest of us.
>
>Yes, but how i can use ADO by remote view of VFP6,
>when i do a remote viewing i can use only an ODBC connection.
>
>thanks

I don't think you can use OLE DB with VFP6 (at least not without the ODBC wraper). You must use ODBC whether you specify the data source or the connect string in the connection setup. Even using a connect string requires a DSN entry. You might want to try a connect string that identifies the provider (sqloledb) and not a DSN. This might possibly work. I haven't tried it yet.

SQL Server 7.0 comes with a OLE DB provider that bypasses ODBC (it has both actually) but you would probably want to use ADO with this.