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.)

 

[TomKane]

Pmitter,

If you get the software developers kit from Pervasive you can use transactional access rather than relative. It's supposed to be much quicker.

Tom

 

[hanso]

Pmitter,

ADO is the engine MS is using for data access, it usually still uses ODBC to connect. You can use Pervasive tools in your app (without having SDK. Just add PVSWInstallpath\BIN\PVDCM.dll as a reference and it will allow you to approach your Pervasive database through the pervasive client.

By the way there are several of these dll's which allow you to control pervasive tools from your VB application (such as PCC)

Hans

 

[hanso]

More info on:

http://www.pervasive.com/library/index.asp?_shownode=EMB

Hans.