Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

"Could not find language driver" when trying to open DBF file with BDE

Posted on 2009-02-17
13
Medium Priority
?
1,739 Views
Last Modified: 2013-11-24
Hello,

I have to update an application (made with Delphi 2006, uses BDE 5.01) so that it can access four DBF tables used by another application (not simultaneously).

I can open and modify the records of two of the DBF tables normally but when trying to open the other two DBF tables I get a "Could not find language driver" error.

Using copies of those tables I found that if I delete the CDX index file of those tables I can open the table, but I am not allowed to modify the structure nor delete the CDX files of the working tables.

All four tables have its corresponding CDX files.

Also found using an hex file viewer that the CDX files of the problem tables contain the text chain "SPANISH" repeated several times in different positions.

Already tried changing LANGDRIVER and various other settings in the BDE admin and using a 'fresh' BDE install in a different computer to no avail.

Any suggestions?
0
Comment
Question by:gato-san
  • 7
  • 6
13 Comments
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23667308
if you only need read access to the files:
copy only the dbf files to an other location and open there.

what langdriver does the other app use to open the files ?
0
 

Author Comment

by:gato-san
ID: 23667516
I need to append and modify records.

The other application is written with Foxpro. I won't have access to that application until a couple of days from now. For now I'm working with copies of the tables.

As far as I understand this is related to a BDE bug. Any workaround?

I'm going to test some direct access components for DBF tables. Does anybody know of a very reliable one?

0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23667712
are you sure it's not FoxPro tables instead of DBase ?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:gato-san
ID: 23667994
These are the files (letter case is as it appears on explorer):

Gen.cdx
MED.CDX
Per.cdx
SOC.CDX
GEN.DBF
MED.DBF
PER.DBF
SOC.DBF

These belong to an invoicing system.

With BDE I can open "SOC" and "MED", but not "PER" nor "GEN".

I can open all the tables with Excel and some freeware DBF viewer. But not with BDE.
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23668061
did you try changing the file names to the same case ?
it sounds silly, i know
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23668070
that would be all upper ...
0
 

Author Comment

by:gato-san
ID: 23668127
yes, nothing changes

seems to be a BDE bug


0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23668131
have you tried database desktop ?
it should be in the bde directory ...
0
 

Author Comment

by:gato-san
ID: 23668247
of course, using database desktop I get the same bde message
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23668261
sorry, i have come to the end of my solutions,
my guess would be a differrent version DBase

if you create a table with database desktop and add an index
try and open that file with your app.

and have a look at the extension of the index, my guess is it will be different (IDX)

0
 

Author Comment

by:gato-san
ID: 23668294
I can't modify the tables or its indexes as those have to work with the other system and I can't touch that.

I'm trying a 3rd party direct DBF access component.

Thanks anyway

0
 

Accepted Solution

by:
gato-san earned 0 total points
ID: 23703486
Used 3rd party commercial component to access the tables.
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23703618
you didn't post any files so i could only guess ...
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

804 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question