Accessing FoxPro using VB 6.0 SP3 
Author Message
 Accessing FoxPro using VB 6.0 SP3

I use data bound control to access a FoxPro dbf file.  Mye
connect = FoxPro 3.0, DataBaseName= c:\VB, RecordSource
=Omron Canada.
I use a TextBox to look at a data field.  DataSource
=Data1.  But when I try to set the DataField I get the
following error: "The Microsoft Jet database engine could
not find the object 'Omron Canada'.  make sure the object
exists and that you spell its name and the path name
What I found was if I rename the FoxPro database to
say "OMRON.dbf" I have no problem accessing the database.
Is there a problem in VB6 SP3 accessing FoxPro database
with long file name? (I have no problem accessing Access
DB with long file name)

Sat, 17 Apr 2004 03:17:13 GMT  
 Accessing FoxPro using VB 6.0 SP3
Try using the following connection string to access your Fox database:

oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
                   "SourceType=DBF;" & _
                   "SourceDB=c:\somepath\mySourceDbFolder;" & _

Just specify the path to your Fox or dBase file in the SourceDB clause, and
you should be in business. You can then execute "SELECT * FROM tablename"

Hope this helps!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights

Sun, 18 Apr 2004 07:09:34 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Accessing Visual Foxpro 6.0 with VB 6.0

2. VB 6.0 - Visual FoxPro 6.0 Tables and VB

3. Opening a Foxpro 2.6 database using VB 6.0

4. Using FoxPro TLB in VB 6.0

5. Accessing Access DB with password using VB 6.0

6. Accessing Access DB with password using VB 6.0

7. Accessing Access DB with password using VB 6.0

8. using Visual FoxPro Databases in Visual Basic 6.0

9. Using SQL in ADO to call FOXPRO 6.0

10. Slow Foxpro Access Using VB 4.0 DAO

11. Slow Access to Foxpro DB in VB 4.0 using DAO

12. VB 6.0 SP3 Error, HELP


Powered by phpBB® Forum Software