Hi Craig,

Thanks for your reply

My connection sting is:
"DSN=Visual FoxPro Tables;UID=;SourceDB=" + pathName + ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=No;DBQ=" + pathName + ";";

How can I change it to bypass ODBC and go directly through OLE DB?

Cheers,
Ali


>It depends on how you setup your OLEDB connection string. If you put DSN=SomeDSN, then you'll go through ODBC and OLEDB.
>
>Another way you can access the data is to go directly to OLEDB and bypass ADO (ADO is basically a COM wrapper around OLEDB). However, I have no idea how you would do this.
>
>Still another option is to write a COM component in VFP, then access that from the VC++ program.
>
>>Hi Everybody,
>>
>>I need to use VFP tables in VC++. I know about two options: ADO and ODBC. I would like to use ADO because users don’t need to do extra work for defining a Data Source. The problems are:
>>1) It takes a long time, to open a table with (let say) 100,000 of records in VC++.
>>2) To go through records and assign values to them, would take much more time than in VFP environment.
>>
>>Do VFP tables support OLE DB? Or they have to go through ODBC first? Does anybody have a better idea or whatever for accessing DBF tables in VC++?
>>
>>Thank you for you help,
>>Ali