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!
|
>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.
|
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?
|
|
Any thoughts? Anything else I could try?
|
Main
webmaster@hxtt.com