• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

.dbf file interaction in coldfusion

Community Beginner ,
Mar 12, 2015 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

919

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
community guidelines
LEGEND ,
Mar 12, 2015 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,

^_^

Votes

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
community guidelines
Advocate ,
Mar 12, 2015 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

Votes

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
community guidelines
Community Beginner ,
Mar 18, 2015 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.

Votes

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
community guidelines
LEGEND ,
Mar 20, 2015 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,

^_^

Votes

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
community guidelines
Community Beginner ,
May 12, 2015 May 12, 2015

Copy link to clipboard

Copied

LATEST

Thank you WolfShade. Appreciate your reply.

Votes

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
community guidelines
Resources
Documentation