.dbf file interaction in coldfusion

[Chandrakantab]

How to use dbase (.dbf) file in ColdFusion. How to connect the same, datasource creation and query to get data?

This is for windows?

[WolfShade]

Near as I can tell, CF doesn't support .dbf (dBASE) databases.

According to my CF10 Admin panel, under Data Sources, you can work with:

• Apache Derby
• DB2 (which I don't know if DB2 works with .dbf files, or not)
• Informix
• JNDI / J2EE
• Microsoft Access
• Microsoft SQL Server
• MySQL
• ODBC Socket
• Oracle
• PostgreSQL
• Sybase

HTH,

^_^

[haxtbh]

I think this will depend on what version of coldfusion and windows you are running.

If they are quite old this link may point you in the right direction - Connecting to dBASE/FoxPro Databases

Otherwise if you have CF 10+ you can do something like this - Connecting ColdFusion 10 to FoxPro 9 | CFchimp

[Chandrakantab]

Thank you all. yeah, I checked everything, but it doesn't look like working in ColdFusion 9. Tried to use ODBC connection and it really not working.

Any suggestion for CF 9 + Windows OS + dBase ?

Thanks for help again.

[WolfShade]

According to this post, dbase support was dropped from ColdFusion back in CF5.  However, there is a URL provided in one of the answers that looks like it provides instructions for later versions of CF (like 9) to connect to dBase via a custom JDBC driver.

HTH,

^_^

[Chandrakantab]

Thank you WolfShade. Appreciate your reply.