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

Need help reading a .mkd file (pervasive sql)

Need help reading a .mkd file (pervasive sql)

(OP)
We recently acquired a company who uses Pervasive SQL as their database. We just received a bunch of .mkd files. Do you know of an easy way to read these files? I assume that I would have to receive a Pervasive SQL ODBC driver? We are a SQLServer shop...

Thanks,
Bessebo

RE: Need help reading a .mkd file (pervasive sql)

You should consider posting this in the Pervasive forum.  Posting it here is like posting a windows XP question in a windows 95 forum.

But, to attempt to answer your question, you should have some .ddf files as well.  If you have them then you can install Pervasive ODBC drivers, which will need the .ddfs.

I am unsure how you are going to install Pervasive ODBC without actualling installing the Pervasive database engine however.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

RE: Need help reading a .mkd file (pervasive sql)

(OP)
I apologize. I thought I was actually in the Pervasive forum...

RE: Need help reading a .mkd file (pervasive sql)

Either this forum or http://www.tek-tips.com/threadminder.cfm?pid=318 is fine for posting Btrieve/Pervasive questions.  
This forum (Pervasive: Btrieve) is probably geared more toward  older versions of Btrieve.  

As for your quesiton, how you access Pervasive/Btrieve files depends a lot on what version of Btrieve/Pervasive you've got.  You mention .MKD file and "Pervasive.SQL", this tells me you've got a more recent version that may already have an ODBC driver included.  If it is, it'll be listed as "Pervasive ODBC Client Interface" and "Pervasive ODBC Engine Interface" in the ODBC Administrator.  Before you can use ODBC (or any of the relational access methods), you'll need DDF files (FILE.DDF, FIELD.DDF, and INDEX.DDF).  Once you've got the DDFs, you can create an "Engine Interface" DSN at the server and a "Client Interface" DSN at the client.  Then your ODBC enabled application (Access, VB, C#, etc) can access the data.

If you need more information, please post more information about what you're doing, the version of PSQL installed, and whether you have DDFs or not.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Need help reading a .mkd file (pervasive sql)

(OP)
My problem is that all I have is the .mkd files and the .ddf files. I don't have a database engine. For example, if it were a SQLServer database file, all I would have is the .mdf file and no installation of SQlServer itself. So, I have no clue what version of Pervasive.sql that I have. I think all I need is an ODBC driver which I do not have. Then I can export them to any format that I want.

Regards,
Bessebo

RE: Need help reading a .mkd file (pervasive sql)

Well, a few things:
1. You need a PSQL engine.  Ideally you would use the latest release of the same version that was used to create the files.  
2. To use ODBC, you need DDFs.  If these files are from a third party application, I would suggest contacting the vendor to get DDFs.  If this was a custom app, I would suggest creating the DDFs and associated table entries using CREATE TABLE statements (or PCC Create Table Wizard or DDF Builder).  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Need help reading a .mkd file (pervasive sql)

(OP)
These are from an enterprise system called Business Works. ALl we got was the files, including the DDFs...

RE: Need help reading a .mkd file (pervasive sql)

The business works install had to have a Pervasive engine.  If you acquired the company, did you not acquire the server with Pervasive on it?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

RE: Need help reading a .mkd file (pervasive sql)

Okay, I misread your post.  I didn't realize you had the DDFs.  At this point, you need a PSQL engine.  A trial version is available from http://www.pervasive.com/downloads.  
The PSQL engine is the only way you'll be able to read the PSQL files.  Just like SQL Server MDF files need a SQL Server installed, MKD files need a PSQL engine.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Need help reading a .mkd file (pervasive sql)

(OP)
OK Thanks for your help...

RE: Need help reading a .mkd file (pervasive sql)

(OP)
Hi,
 I am wondering if you know of a default username and password for an administrator in a pervasive.sql database would be? In SQL it is sa and there is a blank password. I am trying to get a username and password from the company that we acquired but I'm not sure if anyone there is going to know it. I created the database and pointed to the database files but when I try to access them from the Pervasive.sql Control center it prompts me for a username and password. Any help?

Thanks,
Bessebo

RE: Need help reading a .mkd file (pervasive sql)

Actually, there is no default user or password on a PSQL database.  Now, some apps (Businessworks included) will set a username/password on a database.  I'm not familiar with BW so I can't tell you what they default to but one of your BW experts should be able to help.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Need help reading a .mkd file (pervasive sql)

There is a BE forum on TT as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

RE: Need help reading a .mkd file (pervasive sql)

If you have installed the Pervasive drivers you can download BtSearch32 at www.nssdd.com and it will allow you to view your data.  When selecting one of the files in the DDF files if you are prompted for an owner name then you will have to try and obtain that owner name which is not likly to be provided.

Gil

RE: Need help reading a .mkd file (pervasive sql)

(OP)
We have no BW Experts as we purchased a company that uses Business Works and they have no experts. So we are trying to acquire a username and password from one of the representatives of the company that we purchased. They had no experts but they did have users of the system. Hopefully if I get one of those usernames and passwords I will be able to view this data...

Thanks,
Bessebo

RE: Need help reading a .mkd file (pervasive sql)

Post this in the BusinessWorks forum, someone there may be able to help.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

RE: Need help reading a .mkd file (pervasive sql)

(OP)
OK Thank you...

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