Connect to Fox Pro db?

[savok]

Can someone post an example of how to connect to a foxpro database?

this is how i do it with access, how would it work this foxpro? thanks

Dim Conn As New ADODB.Connection
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Phase3.mdb;Persist Security Info=False;"
Conn.Open

 

[link9]

Here's a page with a ton of examples of all sorts of dsn-less connection strings (including FoxPro)

http://www.basic-ultradev.com/articles/ADOConnections/

good luck!
Paul Prewett

 

[WildBillH]

Try this:

"Provider=MSDASQL.1;Extended Properties=DSN=Visual FoxPro Database;SourceDB=g:\MyFolder\MyVFPDatabase.dbc;SourceType=DBC;Exclusive=No"