Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Btrieve from VB5

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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

916 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