Btrieve v5.0 and VB.NET - How to Connect and Export (only selected records)?
Posted on 2004-08-09
Hey I have a Btrieve DB version 5.0 that I need to export records into a text file. I know that I could just use the butil utiltiy and export the DB to a CSV file, but I do not need all the records, only ones that are from within is a certain range (i.e. I would like to be able to use BUTIL with a SELECT statement, but that is not an option). This process has to be done everyday.
I know I am using an old version of Btrive (very old, not even v6.15) but this is what I have and we cannot (or will not) upgrade. After reading up on it, I think my option is use ODBC to connect and I am going to VB.NET to handle it. But I do not know where to begin. I do not know what ODBC driver to use (most I have seen are for v6.15 or Pervasive.SQL7 (or newer). Are their drivers out there for Btrieve 5.0?
Also can some give me some examples of how to start this task in VB.NET not VB6. Or does anyone have any other ways that this may be performed, and if you do please also provide some examples because I probablly will not know how to do it since I am very new to Btrieve...
If people know of other tools (command line (i.e. DOS), not WIN32) that I could use for this task that would be great too.
Also I have to ask the admin of this system but I am not sure if he has the DDF files, so if they are needed in your solutions please make a note of that.