Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement