Solved

Btrieve from VB5

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
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…

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

18 Experts available now in Live!

Get 1:1 Help Now