Need Help with connecting to a database

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:
8.60.192.30, 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.

Thanks,

Ed


.

Relevant Pages

  • Re: SQL Permissions
    ... No, the SQL User in the database you move, will not be lost; ...
    (microsoft.public.sqlserver.security)
  • Lost Password
    ... I have a client who handed me over an NT box with SQL 6 on it. ... database that hasn't been touched in 5 years and he lost the password to ... both NT and the SQL database. ...
    (microsoft.public.sqlserver.security)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)