Anyone no how to open a Visual Foxpro Database with ADO
I can successfully open ADO with Access but not
Visual Foxpro Table.
Anyone have code for this?
Bruno
Printable View
Anyone no how to open a Visual Foxpro Database with ADO
I can successfully open ADO with Access but not
Visual Foxpro Table.
Anyone have code for this?
Bruno
Hi, i didnt work on Visual FoxPro but i think u need to use a DSN to work with ur DB. U can do this by going to Control Panel -> ODBC32 bit and Creating a DSN by choosing the appropriate driver from the list. I think this should help you in connecting to ur database and if u r successful u will find it that life is easier for u using ADOs.
Hope this gives u some idea. Please keep me informed. All the best...vijay
Here's the connection string for Visual Foxpro, also works for DBase. Just remember that the <path> tag points to the folder where the .dbf files are and not the .dbf file itself, your recordset object would then reference the .dbf's filename without the extension.
cnADO.ConnectionString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=<path>;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu ll=Yes;Deleted=Yes;"