Solved

Btrieve from VB5

Posted on 1997-08-05
4
310 Views
Last Modified: 2008-03-17
I need to access a Btrieve database from VB5 Professional. According to the VB Books Online, this is done through an Installable ISAM, but Setup doesn't list Btrieve as an option. Any ideas on this? How do I get the Btrieve IISAM?
0
Comment
Question by:rbroome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:cymbolic
ID: 1429787
Easy. Check out www.btrieve.com.  They've changed their name to Pervasive Software since being let go by Novell, but they have the Btrieve Workstation Engine and the 32 bit ODBC driver that you need.  Another resource is Intersolve, but they are quite a bit more expensive
0
 

Author Comment

by:rbroome
ID: 1429788
I know there are add-ons you can buy, such as Smithware's ActiveX Controls for Btrieve, but my understanding from the VB doco is that there is support built in. I shouldn't need to buy add-ins for basic Btrieve processing!
0
 
LVL 9

Accepted Solution

by:
cymbolic earned 50 total points
ID: 1429789
ISAM stands for Indexed Sequential Access Method.  This was the name for the native access method in Professional Basic, which evolved significantly in VB.  As a generalized term, it could be applied to Btrieve files, since they are sequential (one record after another), and they do contain indexes.  But, you are using either the JET database engine or direct pass through to some ODBC driver to get to your data base types in VB.  If you look at the pull down in import or link on MS Access, you can see what types are natively supported.  Btrieve is not one of them.  You get there through an ODBC driver, which does not come with VB.  Usually, if you have Btrieve installed on your system, somebody already has the driver, they just aren't using it, but it came with there Btrieve installation package.  If using Pervasive, don't use anything less than release 2.0.

Without the driver, and without associated .DDF files, VB access methods such as DAO or RDO don't get it

The reason setup does not list Btrieve as an option, is becuase it isn't an option.  You must acquire it somewhere else, install it, set up an ODBC data source, and either connect directly to it, or indirectly through MS Access links.  www.btrieve.com is still your best bet.  They know Btrieve best.  They built it.

I know you'd like to get it free from Microsoft with VB, but it just ain't there!
0
 

Author Comment

by:rbroome
ID: 1429790
All you have said is true, and I appreciate the information. However, the whole point of my enquiry was that VB3 and VB4 come with an Installable ISAM  for Btrieve. It is even selectable as a data source from a Data Control. It would seem, however, that with VB5 they have stopped this support. This was even a surprise to the Microsoft support person I spoke to here in Australia. He is currently seeking official confirmation from Microsoft US on this. The VB Books Online that ships with VB5 even mentions Btrieve as a supported data source (in the same category as Dbase, Foxpro, etc.

So thanks for the help, but it hasn't really helped. I was intending to get the Cvtaive X Controls for Btrieve, but there is a 2 weeks+ delay in getting them. As my client wanted to see something sooner than that I was hoping to be able to use the standard facilities as an interim step.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month6 days, 10 hours left to enroll

636 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