Anyone no this?

[bservello]

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

[bar]

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;Null=Yes;Deleted=Yes;"