How to connect ODBC to FoxPro 2.6 DBF Files
Posted on 2005-03-18
I have 2 DBF files from a FoxPro 2.6 database program. I have them in thier own directory and have created a system dns called "bbank_legacy" by using the Microsoft FoxPro VFP Driver. I changed the options to "Free Table Structure" and pointed it at the correct folder. I then wrote the following ASP Page:
Set conn = Server.CreateObject("ADODB.Connection")
RS.Open "Select * from BBANK", conn
While not RS.EOF
Set RS = Nothing
Set con = Nothing
When I run this file, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]File 'bbank.dbf' does not exist.
/testing/foxpro1.asp, line 9
Anyone ever worked with FoxPro 2.6 DBF files? I really need this, so 500pts!