ACCESS FOXPRO DATABASE WITH VB6

[07sprint]

ACCESS FOXPRO DATABASE WITH VB6

I get a error message:
[Microsoft][odbc.driver manger] data source not found and no default driver specified.

Set cn = New ADODB.Connection
cn.Open "Driver={Microsoft dBase Driver(*.dbf)};" _
& "DriverID=277;" _
& "dbg=D:\PerCap1;"
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.ActiveConnection = cn
rs.Open "Select * from PerCap2"

 

[bjd4jc]

should be dbq=D:\PerCap1;

and not

dbg=D:\PerCap1;

Have you downloaded the latest version of MDAC?

 

[07sprint]

I have version 2.8 MDAC

 

[07sprint]

I still get this error message:

[Microsoft][odbc.driver manger] data source not found and no default driver specified

 

[07sprint]

I even try this code:

Dim strFilePath As String
strFilePath = "Data Source =D:\PerCap1\PerCap2.dbf"
Set cn = New ADODB.Connection
cn.Open "Provider = Microsoft.Jet.OLEDB.4.0;" & _
"strFilePath" & ";" & _
"Extended Properties=dBase IV;"

I get this Error Message:

Could Not Find Installable ISAM

 

[07sprint]

I keep getting error message

 

[rjean]

Are your DBF's contained in a DBC? If so, you should use that type of access vs. just going at the standalone DBF files. Gives you more of a true client/server type access and you will have access to all tables in the DBC within one connection.

I'm doing the following from ASP and it works great. I had to install the VFP OLEDB provider which is not part of MDAC but you can get it from the VFP download page:

http://msdn.microsoft.com/vfoxpro

UNCDATAPATH is a constant.

Set objConnection = Server.CreateObject("ADODB.Connection&quot

strOpenString = "Provider=VFPOLEDB.1; " & _
"Data Source=" & UNCDATAPATH & "\PTRAK.DBC; " & _
"Mode=ReadWrite|Share Deny None; " & _
"Cache Authentication=False; " & _
"Encrypt Password=False; Collating Sequence=MACHINE "


objConnection.Mode = 16
objConnection.CursorLocation = 3

objConnection.Open( strOpenString )

 

[07sprint]

I get Error Message:

Provider cannot be found.

It is in C:\Program files\common files\system\ole db

 

[rjean]

Sounds like the DLL is not properly registered for some reason on that machine. Check out the following KB article to see if that helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;278604

 

[TomKane]

Try using the data conrol it has foxpro as an option as part of its connect property

 

[07sprint]

How do you connect by using connect property.

new to this