I've been trying now for a week to figure out how to connect to a Pervasive
Database and I've tried so many things that I'm completely lost.
What I need to do is access a set of btr files using SQL because there are
several files that need to be joined. But before I even get there I lost.
I've done several ado, MS SQL and DB AS400 projects, but I don't know where
to go from the start with this.
The remote PC has Pervasive ODBC Client Interface Driver loaded vs:
22.214.171.124, it has the necessary files: FILE,FIELD,INDEX,VIEW.DDF files
and the viewstbl.dsk file. I'm not on the server, but I have a mapped drive
(s:) to the directory where these files reside. I know that everything
works on the PC because the client is running their apps from here and I was
able to find a couple of delphi example programs that will also read the
files. The one that works is called: Btrieve Database Desktop (BDBD32.EXE)
from Polukot in Russa, but I can't get a hold of him and there is no source
code. This program doesn't even ask about the ODBC, you just pick the path
that the ddf files are in and it gives you a list of the dbs and then you
can double-click on the db and it opens it.
Need to figure out what component set I have to use to access the db in this
method. It tried to load OLE driver on the remote pc, but it gave me the
error: 'A Pervasive.SQL engine was not found on your system.' on
installation. I don't even think I need it because the bdbd32.exe program
example above ran without it.
This is what I'll will be doing with the program and what I do now:
I have a service app that starts a second app once a day.
The second app connects to a db, extract the data based on a date range
to a tabbed delimited file.
So I guess this is what I need to do:
1. Figure out how to access the databases via SQL.
2. Need to do it very cheaply. This is a test that I'm doing for another
company and I'm not even getting paid for it.
3. A couple sample btrieve sql statements doing outside joins.
Please help, I'm passing the point of not saving face.