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?
FoxPro 2.6
requires a dll calledmsxbse35.dll
Copy it into your system32 directory and run
regsvr32 msxbse35.dll
to register. Your program will then run fine on that computer.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