Connecting to Btrieve with VB 6

[pmitter]

I am trying to figure out the fastest connection to Btrieve files (Platinum for Windows) through Visual Basic 6. Running Pervasive.sql Version 7.0. Have been writing programs in Visual Foxpro using ODBC connections up to this point. I've heard Visual Basic can access faster - through ADO? I don't seem to have the activeX files to add in that I need.

Any help or suggestions would be much appreciated. Is the Pervasive 2000 engine easier to do this than version 7? (though I'm not sure if we will be upgrading or not.)

 

[mirtheil]

With VB, there are several options for accessing Btrieve data. You can use, in order from fastest to slowest, the Btrieve API, ActiveX control, ODBC. Since you're using 7.0, the ODBC would be different than if you use Pervaisve 2000. Personally, I use the Btrieve API, it's a little more work because of some VB limitations (alignment of user defined types is the first thing that pops to mind) but is going to be the fastest method for getting the data in and out. There is a white paper on Pervasive's web site that talks about the various choices in VB but it's geared for Pervasive 2000. For samples, you'll need the SDK from Pervasive.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[pmitter]

Thanks - I'm still waiting to find out if we will be upgrading Pervasive to 2000. I have seen where to download the 2000 SDK on the pervasive site, but can't seem to find the Version 7.0 SDK - only the online manuals for it.

 

[grnelson]

I've been using the ActiveX controls from Pervasive and like them the best for development. While I wrote BtSearch my Pervasive Btrieve utility program using the Btrieve API and the extended calls to get the best performance I find that for every day development the ActiveX controls are great.
Gil