FoxPro ODBC datasource

[cmmrfrds]

I tried to setup an ODBC connection to FoxPro files in an ACCPAC version 6 database. There is a Visual fox pro odbc driver on the PC.

I do not work with foxpro, so, I am not familiar with the structure and naming conventions. I expected to see files in the foxpro data directory with suffixes of vfp instead there where files with dbf and cdx suffixes. I tried to connect to one of the dbf files and it gave me an error.

What suffix should I expect to see? Am I using the wrong odbc driver - it was the only foxpro driver on the PC. How should I go about setting up the ODBC connection?

Thank you

 

[madonnac]

DBX is the database
CDX is the index

You can link the files using access (i havn't got any foxpro files to try it on) or open it using a recordset, which would then allow you to specify the index

 

[cmmrfrds]

Thank you for the response.

I am at a disadvanatage since the files are at the clients site and I don't have foxpro on my pc. Is there any free foxpro odbc drivers available that I could test with. Do I need anything other than the data and index file? Do I need any other foxpro software on my pc besides the files and odbc driver? Do I want to be using the visual fox pro driver?

 

[cmmrfrds]

I found some dbx files on my PC in the microsoft outlook directory. Also, discovered that I do have 2 visual fox pro odbc drivers one refers to database and one to tables. I tried to setup a connection to one of the dbx files in Access and I get an error that says no messages available.

Any hints as how to setup this odbc data source?

Thank you

 

[cmmrfrds]

Can somebody tell me the steps to setup an ODBC connection to forpro tables. I cannot seem to get the odbc setup correctly.