VB6 - A foxpro 2.6 no isam error on XP

问题:

The boss handed me some rather ancient legacy code, all done in VB6. After installing Visual Studio 6 and a few other things, I'm finally able to open the project and actually compile/run it. My new problem comes from this line of code:

Set db = DBEngine.Workspaces(0).OpenDatabase(ThePath$, False, ReadOnlyFlag, "FoxPro 2.6;")

I get the error "Cannot find installable ISAM"

I'm not sure what I'm missing. I've done some searching and I have things like MSJET35.DLL in system32 and the registry. Access is installed (I tried it with both Access 2002 and 2003). I would expect this to be a problem with Windows 7 or Vista, but this is in XP, service pack 3.

Any thoughts anyone?

回答1:

The FoxPro drivers are not included in MDAC 2.6 and beyond. Download the appropriate install for either ODBC or OLEDB

FoxPro ODBC drivers
FoxPro OLEDB drivers

回答2:

FoxPro 2.6 requires a dll called msxbse35.dll

Copy it into your system32 directory and run regsvr32 msxbse35.dll to register. Your program will then run fine on that computer.