Solved

Btrieve from VB5

Posted on 1997-08-05
4
296 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
  • 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

803 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