Is it possible for ColdFusion to query a FoxPro database?
Yes. FoxPro database structures are derived from DBase. The way you set up the datasource is that the datasource does not point to a file (like an Access MDB) but rather to a directory. Then, any database files in that directory can be used in a query (note: you can also use files that are not in the specified directory as long as you use paths). One weird thing about DBase (and maybe FoxPro as well) is that the default in the ODBC setup is for ODBC to return even deleted rows. If FoxPro is the same as DBase then you need to disable this manually from the ODBC setup (not from CFA). FoxPro ODBC drivers, like DBase, are single threaded (and blocking) which means that only one query can be running at one given moment. If you are doing lengthy queries you will notice a degradation in other simultaneous queries.
