I'm not genius, My name is not Sergey Berezniker :-)
>Hola Esparta,
>Are you genius!!?? That worked out great
>Caho,
>Ali
>Try with
>> "Provider=vfpoledb.1;Data Source="+pathName+"Password=MyPassWord;
Collating Sequence=machine"
>
>
>See also http://www.connectionstrings.com
>Hope this helps
>>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 ActiveX Data Objects (ActiveX Data Objects 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 Visual FoxPro, then access that from the VC++ program.
>>
>>>Hi Everybody,
>>>
>>>I need to use Visual FoxPro tables in VC++. I know about two options: ActiveX Data Objects and ODBC. I would like to use ActiveX Data Objects 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 Visual FoxPro environment.
>>>
>>>Do Visual FoxPro 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