Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Btrieve from VB5

Posted on 1997-08-05
4
Medium Priority
?
316 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

721 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