How do you connect to Btrieve without ODBC

[dont_spam_on_me]

I have been connecting to my Btrieve 6.15 database using ODBC from the 1.0 -
2.04 and I have used Intersolv and Merant drivers as well. I just can not
seem to get good speed out of the driver.

I have a program that also attaches to the same data not using ODBC, but the
speed is easily 10x what I am getting from ODBC.

How do I attach to a Btrieve 6.15 servers data without using ODBC. Are
there any examples on line so I can look at code for VB 5 or VB 6?

[John Pollard]

Use the Btrieve API libraries that come with the client.
--
John Pollard
SWS Systems, Inc.
jo...@swssys.com
dont_spam_on_me <dont_sp...@home.com> wrote in message
news:m9fo4.17$O42....@news.shore.net...

[Jon Grieve]

With Btrieve v6.15, ODBC was very much a 'bolt-on' and as such suffered from
speed issues. The original (and most would say, the best) way to access
your data is using the Btrieve API; direct calls straight to the engine.
This is obviously what the other application is using.

To gain access to the API, you'll need to SDK. Unfortunately, Btrieve v6.15
is no longer available, so the SDK can't be bought any more. However...

Btrieve has been replaced by Pervasive.SQL. Pervasive.SQL has a much more
robust and considerably faster ODBC interface, so moving to the latest
version of the engine will probably mean you don't need to investigate the
API route anyway. If you do want to go down the API route, Pervasive.SQL
also has the advantage of being supported and available ;-)

Regards,

Jon Grieve
Southdown House Software Ltd.
--
http://www.southdown.co.uk
______________________________________________________

The U.K's #1 distributor for Pervasive Software.

Tel: +44 (1306) 877998
Fax: +44 (1306) 887755

[mrucker]

I have written an Access App that does this.

www.worldpath.net/~mrucker

dont_spam_on_me wrote in message ...

[Steven Doggart]

Jim Kyle has a good example of a simple VB class module which provides
basic btrieve functionality. It lacks a lot of functionality and and
error checking, but it's a good place to start. A nice example of how
to interact with the BTRCALL() API function in VB.

His web site is http://www.jimkyle.com/

Basically, all you have to do is declare the BTRCALL function. All the
Btrieve operation are done by calling this one function. The Pervasive
documentation describes in depth how to use BTRCALL.

[Django Dunn]

I use Titan's BTrieve component and I get pretty fast access. It hooks up
to the transactional engine only for P2K programs but it gives you access to
6.15 -> P2K. It's a shell for the API.

www.regatta.com

Django