Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Accessing Foxpro DB From Linux vs Windows
Joseph Gooch
2007-12-27 12:10:40.0
I've been accessing a Foxpro database for quite some time from Windows without any problems, but when I try to access from Linux, the long column names don't show.

I believe it's a VFP 6 database. (We access the data, we didn't create the database) There are DBC/DCT/DCX files which possibly define the long names, as well as dbc_flds/dbc_indx/dbc_ri/dbc_tabl files, and in a folder with the same name as the dbc, there's a coremeta dbf which also contributes to the long column names as far as I can tell. I'm not sure which files are relevant to the long column names so I'm not sure where to look.

Is there any specific type of case that I should be using? Should everything be lowercase?

So, to sum it up, on Windows with driver 4.0.013 I can read from a DBF file and it transparently brings in the long column names from somewhere. In Linux, using the same driver and client, I can read the same DBF without long column names, and some dbf's break because the Indexes based on long column names can't be resolved. Since I'm not sure where the column names are coming from I'm not sure how to help troubleshoot the issue.

I tried to create a VFP database for testing, but the support article you have where you create a VFP database does not create the related memo file so it won't open the table... and I'm not sure how to make my own dbc.

Any help you could provide would be appreciated.

Thanks!
Re:Accessing Foxpro DB From Linux vs Windows
HXTT Support
2007-12-27 17:46:33.0
>but when I try to access from Linux, the long column names don't show.
>Is there any specific type of case that I should be using? Should everything
>be lowercase?
Because it failed to find those DBC/DCT/DCX files on Windows from Linux. You can try jdbc:dbf:////yourdirpath/yourDBCFileName.DBC as jdbc url to see what will happen.
Re:Accessing Foxpro DB From Linux vs Windows
Joseph Gooch
2007-12-28 07:10:50.0
In linux it says filename.dbc isn't a database. In windows it says filename.dbc isn't a database path.

Windows is running JVM 1.6.0_03-b05 (32bit). Linux is running x86_64 vm 1.6.0_02-b05 (amd64 bit). Could the 64bit vm have something to do with it?
Re:Accessing Foxpro DB From Linux vs Windows
Joseph Gooch
2008-01-03 09:14:44.0
Any thoughts? Anything else I could try?

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap