Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help reading a .mkd file (pervasive sql)

Status
Not open for further replies.

bessebo

IS-IT--Management
Jan 19, 2001
766
US
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
 
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

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
I apologize. I thought I was actually in the Pervasive forum...
 
Either this forum or 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
 
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
 
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
 
These are from an enterprise system called Business Works. ALl we got was the files, including the DDFs...
 
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

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
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 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
 
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
 
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
 
There is a BE forum on TT as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
If you have installed the Pervasive drivers you can download BtSearch32 at 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
 
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
 
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

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top