INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

btrieve6.15 and WinXP Odbc32

btrieve6.15 and WinXP Odbc32

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

RE: btrieve6.15 and WinXP Odbc32

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

RE: btrieve6.15 and WinXP Odbc32

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

RE: btrieve6.15 and WinXP Odbc32

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

RE: btrieve6.15 and WinXP Odbc32

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

RE: btrieve6.15 and WinXP Odbc32

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close