Connecting to a FoxPro Database

[CoolWriter]

Hi,

 

I know how to connect an Access database but I don't know how to connect a FoxPro database. What is the syntax for that?

 

Thanks...

[NewToC]

You are going to need to use ODBC instead of OLEDB

[Geras]

Dim directory as string

dim cnn as new adodb.connection

dim rs as new adodb.recordset

 

Set cnn = New ADODB.Connection

Set rs = New ADODB.Recordset

 

directory = "C:\Database"

cnn.Open "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF;" & _

"SourceDB=" & directory & "; Exclusive=No;"

 

rs.Open "DB.dbf", cnn, adOpenStatic, adLockPessimistic, adcmdtable

 

'(or if you want to use SQL instruction...)

dim sql as string

sql = "SELECT * FROM DB"

 

rs.Open SQL, cnn, adOpenStatic, adLockPessimistic

 

E é só isto o que é preciso para conectar através do VB com uma base de dados FOXPRO, mas só se consegue isto se tiveres o FoxPro instalado na máquina.