>Hi,
> I have a database which was being used through Codebase. I have no knowledge of codebase. I wonder whether I can use the VFP 5.x ODBC drivers to access codebase database. If not, where can I find ODBC drivers for Codebase stuff? Are there any version conflicts?
Codebase is a third party product that manipulates data - specifically xBASE data, without the use of ODBC from various languages; I'vce used it in the past in C programs to access FoxPro tables where ODBC was not available to the application (for example, in DOS programs that needed to access tables created in FoxPro or Visual FoxPro.) Tables created with Codebase should be readable and writable with VFP; older versions of Codebase (pre version 6 I believe) could not deal with tables with the extended VFP headers or the new data types in VFP.
Codebase was able to read and write both .IDX and .CDX files when I last used it; if the tables created with Codebase use .NDX or .MDX files, the indexes will likely not remain in sync if records are added by VFP, so reindexing within the Codebase environment may be necessary.
If you're trying to access Codebase-created data in VFP, try opening the tables with the USE statement; ODBC should not be necessary within the VFP environment. If you're looking for an ODBC driver for a different language, I'd try the DBase and pre-VFP FoxPro drivers before trying the VFP ODBC driver.