Solved

Need Borland Database repair tool

Posted on 2004-04-27
5
1,652 Views
Last Modified: 2007-12-19
I have a client that is using an application called AutoDoc. It's used by Chiropratics for billing and such. Anyway, they will get an invalid key or index and have to upload the data to have it repaired.  They are getting charged a nice little fee everytime they do this and it's getting frustrating. From the errors I see, it appears to be a database based on Borland. But I'm not sure. Are there tool out there I can test and see if they can repair the database?
0
Comment
Question by:Thirt
5 Comments
 
LVL 3

Expert Comment

by:MikProg
ID: 10927272
Looks like program written on Delphi or Pascal uses Borland database engine to access database. So I ask you what underlying database structure used? Programs written with Borland database engine can interact with lot of databases: Paradox, DBase, various SQL databases and so on. Can you determine what type of database is used.
0
 
LVL 4

Author Comment

by:Thirt
ID: 10927399
Not sure, but I will try to get more info. thanks
0
 
LVL 13

Accepted Solution

by:
TommyTupa earned 200 total points
ID: 10929043
Borland Database Engine(BDE) is analogous to ODBC.  That is to say front end applications may use the Borland Database Engine to access a backend database.  Most often BDE is used as an intermediary between interbase, dbase or paradox.  The way to determine which database is being used you'll have to look in the config file.  You can often times access the config file through the Borland Database Administrator in the Control Panel.  If you don't find it there just search for BDE.exe on the computer.  Once you get in the config file you can find the Database Alias and view its underlying database.
0
 
LVL 23

Assisted Solution

by:rama_krishna580
rama_krishna580 earned 300 total points
ID: 10930277
try this..

Validate, then backup and restore your database using either the command line tools, gfix and gbak, or the GUI tool, IBConsole.

To use command line tools:
First make a copy of your database. Shut down the database and then make an operating system copy of it (gbak will not be able to copy a corrupt database.)
Run the gfix utility against the database using the -mend switch.
Backup and restore your database using gbak.
To use IBConsole:
(This assumes that your server and database are already registered in IBConsole.)
First make a copy of your database. Shut down the database and then make an operating system copy of it (gbak will not be able to copy a corrupt database.)
Connect to the server.
Do not connect to your database, but do hight light it in the left hand pane.
Choose Tools | Validate.
If validate finds errors, chose Repiar.
(You may have to perform the previous two steps more than once.)
Finally choose Tools | Backup & Restore.

http://community.borland.com/article/0,1410,29869,00.html
http://www.bdesupport.com/index.html

R.K
0
 
LVL 4

Author Comment

by:Thirt
ID: 10981480
Thanks for the help! After I installed the actual applicaiton on my PC, I then see all the BDE utilities and yes, it's a paradox database.  So I used the BDEsupport web site and run Tutilty along with Paradox table repair and it appears to have rebuilt the database!!  I'm having the client look at the data and make sure everything is there.

Thanks again all!!!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now