want to read a pervasive ddf with without connecting to PCC

Posted on 2009-04-05
Medium Priority
Last Modified: 2013-12-25
There is a file.ddf
Is there a way to read it to a datagrid?
I want to basically be able to point to the file and open it
this is so we can verify the path to the .dat files
the paths are hardcoded
Also since we use the ddf files to setup the dsn
This has to be able to open the file.ddf with no dsn
Question by:hainansyndrome
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
LVL 18

Expert Comment

ID: 24074321
I'm not exactly sure what you are looking for.  
FILE.DDF is strictly used by the relational engine for ODBC, OLEDB, ADO.NET, JDBC, and ActiveX to link a logical table name to an underlying MKDE data file.  

You can use the Btrieve API to access an underlying data file without the DDFs.  How you do that depends on the programming language you are using.  


Author Comment

ID: 24076474
Allow me to clarify.
I am attempting to write and app that will let me view the file.ddf even on a pc with you pervasive installed.I simply want to be able to see the path info to the .dat files in the ddf
LVL 18

Expert Comment

ID: 24076757
You have to have the Pervasive engine installed in order to read any Btrieve data file.  
What version of Pervasive/Btrieve are you using?  
There are ways of getting the information you are looking for.  
For example, if you already have an ODBC DSN, you can issue a "Select * From X$FILE" to get all of the information including the path in the DDF.  
If you are using a later version of PSQL (PSQL 2000i, V8, V9, or V10), you can use DTI (Distributed Tuning Interface) or DTO (Distributed Tuning Object) to get the list of tables and paths from a Database Name.
As a last option, you can use the Btrieve API to open and read the FILE.DDF.  The structure is subject to change though.  I've done this in my DDF Path Fixer program.  
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.


Author Comment

ID: 24076826
let me give you more back ground

our techs are having to get connected to our customers servers to create an engine dsn

the pervasive software is not ours, we partner with this other company.
I am trying to avoid the techs fidling with making dsn's with wrong ddf's

so i am trying to figure a way to validate the ddf's first.
LVL 18

Expert Comment

ID: 24077031
The best thing I can suggest would be to create the DSN with the existing DDFs and then validate the tables using PCC or ODBC Test or the application.  

I'm not really sure of a way to validate the DDFs without actually opening them and reading them.  

There really should only be one set of DDFs per data set.  If you've got a third party application that stores it's data and DDFs in the same directory, it's pretty safe to assume that the DDFs are correct for the data.  If you've got a different directory structure, you might have to develop a pattern to look for (data in "data" and DDFs in a "ddf" directory both under the application's directory for example).
LVL 28

Expert Comment

by:Bill Bach
ID: 24077471
If you want to just check on the information contained within the DDF's, and you have the Pervasive engine available, then you can use Goldstar Software's FPRINT tool.  (www.goldstarsoftware.com/tools.asp)   This tool has a free trial period, and it allows you to print out (to the screen or to a text file for printing) the contents of the DDF's very easily, without creating a named database first.  To JUST check the file information, try using "FPRINT * /B" to print the Btrieve file data for each table.

Of course, this only displays the contents of the DDF's -- it does not validate them.  I'm assuming that you're wanting to check for the presence of the proper fields and such.  In that case, use FPRINT /A to get *all* details out of the DDF's.

Note: If the DDF's are built with PSQLv10 and use V2 metadata (PVFILE.DDF instead of FILE.DDF), try getting FPRINT2 instead.

Author Comment

ID: 24077550
I have a 3rd party app, that tells me the info
problem is our techs never read our documentation and they have messed up 3 or 4 customers pervasive install. they get in a hurry and anything that is more than a point and click is not followed
i wanted to write an app that reads the ddf files
then validate that the dsn that they make works later

i figured a first step is to allow them to read the contents of File.ddf
This is me trying to avoid a situation where I am having to clean up after people
LVL 28

Accepted Solution

Bill Bach earned 500 total points
ID: 24077760
Sounds like you need new techs, not a new process.

You can do everything that you want through an application.  In fact, FPrint is an application that works at the Btrieve level.  You can then use the same application to access the Distributed Tuning Interface (DTI) or Distributed Tuning Objects (DTO) to automatically create a new named database based on that information.

With the careful use of a Btrieve application AND some simple VBScript code to access the DTO, it is also possible to create an application like what you want -- one that automatically creates DBNames for an application in the correct location.  I did it for contract work for one client.  It was similar to what you wanted, but it was reading data from an INI file, not the FILE.DDF file, IIRC.  It does show that an automated process is possible, though...

Author Comment

ID: 24077801
I agree we need new techs, but what are you gonna do,
I will give your idea a shot and see if it meets our needs
thanks for the assist

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question