Highlighted

.dbf file interaction in coldfusion

Community Beginner ,
Mar 12, 2015

Copy link to clipboard

Copied

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

This is for windows?

Views

737

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

.dbf file interaction in coldfusion

Community Beginner ,
Mar 12, 2015

Copy link to clipboard

Copied

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

This is for windows?

Views

738

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 12, 2015 0
LEGEND ,
Mar 12, 2015

Copy link to clipboard

Copied

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,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 12, 2015 1
Advocate ,
Mar 12, 2015

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 12, 2015 2
Community Beginner ,
Mar 18, 2015

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 18, 2015 0
LEGEND ,
Mar 20, 2015

Copy link to clipboard

Copied

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,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 20, 2015 0
Community Beginner ,
May 12, 2015

Copy link to clipboard

Copied

Thank you WolfShade. Appreciate your reply.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
May 12, 2015 1