btrieve6.15 and WinXP Odbc32

[okroll]

hi,

i have to read btrieve6.15 data from a third party application.
im using vb6.

the btrieve files have no ddf files, but i have found out the data-structure.

is it possible to create an odbc-entry for btrieve6.15, without to install an Pervasive SQL Engine, couse the customer uses the old btrieve requester...

and if so, where could i find the odbc-driver?

thanks for your help

sincerly

oliver k.

 

[mirtheil]

If you have an ODBC driver for Btrieve 6.15, you can create an ODBC entry. The current ODBC driver from Pervasive will not work with Btrieve 6.15. You need the v2.04 ODBC driver from Pervasive or you might be able to use a DataDirect (aka Intersolv or Merant) driver.
One thing to be aware of, you wiil need DDFs in order to use any ODBC driver. There are several tools available to create DDFs.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[okroll]

hi mirtheil,

i dont have a odbc-driver for btrieve, and i could not find a odbc-drive on the pervasive website.

the ddf should be no probleme, couse i have the data-structure, so i could create them, but no odbc-drivers...

do you have any link for me?

thanks for your help!

oliver k.

 

[mirtheil]

The ODBC driver was a separate product for Btrieve v6.15 workstation engine (and even with the server engine). If you wanted to distribute it, a deployment license was required (I remember because I looked into it at one time but decided to use the Btrieve API instead).
I'm not aware of any links and you aren't going to find that old of an ODBC driver on Pervasive's web site. You might try Data Direct but I don't know their web site.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[okroll]

hi mirtheil,

ok, so i have to use the btrieve api.

do you have any link, where i can find some source (vb6) how to use the btrwcall, in order to do following operations:

- get recordcount
- iterate through datarows
- get a data row by an specific field-value

thanks a lot for your help.

sincerly

oliver k.

 

[mirtheil]

You might be able to find some samples on the Pervasive site. I don't have anything that I can extract to show what you are looking for in a generic way. All of my VB code is taylored for what I need it to do.
That being said, to get a recordcount, use the STAT operation.
To iterate through the records, use a Get or Step (First, Last, Equal, etc) to set positioning then use Get or Step (Next/Previous) to read records.
Getting a record by a specific field value. Assuming the field is indexed, use a GetEqual/GetGreaterOrEqual/etc. If the field is not indexed, you will need to iterate through and check each return record for the value you are looking for.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician