Solved

ODBC To Btrieve Information

Posted on 1997-12-11
3
469 Views
Last Modified: 2006-11-17
Can you suggest a VERY good book or resource for programming information regarding ODBC's links to Btrieve files?  I need to both read, save & modify records in the Btrieve files and have not had great success to date.

 
0
Comment
Question by:jonfinley
3 Comments
 
LVL 5

Expert Comment

by:cekman
ID: 1962083
I don't know of any books, but there are number of articles in the MS knowledgebase that discuss this topic. If you haven't looked there - you might want to give it a try. You can search the KB online under microsofts support page.

Good Luck
CEkman
0
 
LVL 9

Accepted Solution

by:
cymbolic earned 50 total points
ID: 1962084
I have found "Visual Basic and SQL(Server) by W. R. Vaughn from Microsoft Press to be good.  

But I haven't found any ODBC drivers for Btrieve that I can say the same for.  I struggled for some time trying to get that stinking Pervasive ODBC driver to work consistently, but it was always unreliable, and functionally very limited, with extremely poor performance.  

One problem is that my linked tables had too many multisegment index fields, with long text segments (some files were 10% data, 90% index!) and these caused problems in MS Access as well.  Also, date and numeric fields were not typed and constructed properly in the btrieve files, plus I had some bitmasked fieIds to interpret as well.  I finally wound up using BUTIL to extract the btrieve files of interest to flat text files, did a little pre processing to make real date fields, etc, and built import specs in MS Access to get btrieve numeric fields in as real numbers, for crying out loud!  No things work likity split!

You might look into the Smithware ODBC drivers.  You'd think Pervasive would know what they're doing, because they used to be Btrieve, but I guess it tain't so!
0
 

Author Comment

by:jonfinley
ID: 1962085
Do others agree that a good, reliable ODBC driver for Btrieve does not exist?  If so it seems that another language (like C++) should be used to get at the Btrieve files (with the Btrieve SDK libraries), agreed?
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

757 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

20 Experts available now in Live!

Get 1:1 Help Now