ADO Connection String for FoxPro 5

Hello,

I am trying to access a local FoxPro 5
table with ADO, but I'm not sure how to
formulate the connection string. The
table is stored locally and is not
defined as an ODBC source. I also am not
sure which provider to use.

Any help would be greatly appreciated.

Regards,
Erik

[Tonatiuh]

I don't know how to connect it with a DSN-Less way using ADO. Using a DSN is very simple.

cn.ConnectionString = "DSN=Prueba;UID=;PWD=;OLE DB Services=-1;"
cn.Open
cn.CursorLocation = adUseClient 'adUserServer

The recomend you to use the ODBC drivers that coming with Microsoft Office 2000.

I hope it can helps you.

Good Look!

Tonatiuh