setting up a DB connection to a .DBF using CF
Posted on 2005-04-13
I am on an intranet and there's a network drive that has a .DBF file containing a product catalog (price,cost,SKU, etc.) for our sales registers. As of right now there is no way to add/delete/update this catalog unless you use the sofware application tbat uses the file (which is located only on the PC that has the register).
I would like to create a back-end in CF that can be used to manipulate the file's data (change product costs,prices, etc.) using cfquery (SQL) like you can do with an access DB...that way I can manage the catalog from another PC on the network. I've read a limited amount of information about establishing a connection to a .DBF, and it appears it's similar to setting up an excel file.
specifications of note:
using CF MX 6
this is an intranet with several drives and setting up a datasource would not be a problem in CF administrator...however, I are not sure which driver (if any to use)