Accessing Pervasive databases via VB

[timeframe]

I can access the Pervasive/Betrieve databases from Visual Basic by using the Pervasive ODBC driver. But if I want to use a direct connection using ADO is the only option to install the SDK?

 

[ArnaudAbadie]

Well I'm not sure that SDK is required to use ADO.
Have you include Pervasive ActiveX in your project's options.
If so it's ok. You can do what you want.

Hope it helps
Regards
Arnaud

 

[timeframe]

Where do I get the Pervasive ActiveX file do it come with the standard Pervasive installation, and do you know what its called? Thanks for responding.

 

[timeframe]

I've now installed Pervasive's SP3 Beta which has given me ADO capabilities, however it has upset my ODBC connection to .dat files.

I guess the ActiveX comes with the SDK.

 

[brindamgh]

Dear Sir,

Currently we have a software which has pervasive sql
as backend.Right now we use crystal reports to create files
from the database.I saw your reply which says, there is a
Pervasive driver to access the database using ODBC.We have
VB 6.0.Please give me some more details of how to install
the driver and access the database via DAO or ADO.Can we
do it ourself or take help from support service.Please
emphasise on how to access the database via code and do
you suggest DAO or ADO?Your help is greatly appreciated.
Thank you very much.

 

[timeframe]

If you've got Pervasive.SQL 2000 then you can download the SDK developer kit from

http://www.pervasive.com

(or

http://developer.novell.com/ndk/psqlsdk.htm

- scroll down page) which installs ADO capability, and you can now download the SP3(80MB) which also provides ADO capability without the SDK. The SDK has quite a lot of useful documents, and their are some free samples with code for download at

http://www.pervasive.com/componentzone/.

If you install the SDK or SP3 on the Server then it should install the latest drivers automatically, there's a separate setup for Client Workstations.

I'm still evaluating the various connection options. Using the OLEDB provider without ODBC you are limited at the moment to using the Connection and Recordset objects, the Command object is not supported yet. But you can use ADO via ODBC with the command object. I'm going to use ADO as that's the way MS is going and the ADO 'Seek' is supposed to be quick.

Re support, there's a DevTalk forum but its not too active, and there's the Pervasive Knowledgebase.

Re code: see how you get on with the downloads and checking out the samples and docs, and let me know if you need more help. For VB there's also the option of using a Pervasive dll library called DTO, it comes with the SDK, its an interface library. You will probably need to register to download, but it doesn't require any license info I don't think.

Good luck!

 

[jbrowne]

Hi timeframe,

I was wondering how you got on with the using the seek function in ADO to access the Pervasive files. I'm currently doing the same thing but am experiencing inconsistant errors. I can do a seek get a result and next time into the same procedure, the seek throws an automation error or a seek on recordset failed error. I'd appreciate any help on this.

John B

 

[timeframe]

jbrowne: You're ahead of me, I'll let you know.

 

[brindamgh]

Dear Sir,

Thank you very much for your suggestion.I will try
downloading SDK/SP3 and work.If i have trouble,i'll let
you know.

Thank you