• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1271
  • Last Modified:

.DBP Files Convertion

Hi friends,

We are working on a windows based custom software solution using VS 2008 with c#, our client send us few .dbp files and told it contains some useful data and these files were created by some unknown software, these files contains binary data and are around 60-100kb in size.

Now I want to know what are these .dbp file and how can i convert or open them. I am attaching few files for your reference in .zip format (I have changed extention of file to .txt from .dbp as .dbp files are not allowed to be attached.)

thanks in advance.
sample-dbp-files.zip
0
ArunVashist
Asked:
ArunVashist
  • 7
  • 7
1 Solution
 
pcelbaCommented:
.DBP file extension is used for Visual Studio .NET Database project. If you trust your client you may try to open them in VS.NET. It would require additional files or folders to be present on your computer. You have to ask your client for more details.

0
 
Bill BachPresidentCommented:
These files are Btrieve files, created by at least a Pervasive.SQL V8 database engine, with Relational-Integrity constraints on them.  

Because there are RI constraints, you should ALSO have several data dictionary files (*.DDF, including FILE.DDF, FIELD.DDF, and INDEX.DDF, among others).  On your customer system, start the Pervasive Control Center, open the database, and you will be able to use the Export Data Wizard to export the data right to CSV files.  This should be VERY easy.
0
 
ArunVashistAuthor Commented:
Hi BillBach,

You are right even our client told us about this pervasive SQL V8 thing.. well with these file I do have a one User.ddf file, so what software I exactly need to open means how do i know which version to use. any link or reference will be great help.

thanks
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Bill BachPresidentCommented:
You need much more than just the USER.DDF file -- please look in the same folder for the other DDF's.  IN "SQL" terms, the DDF's comprise the system catalog, and they contain the metadata for defining the file structure to the database engine so that the SQL engine can access the data.  They MUST exist, but you might have to hunt for them.

Use the same engine -- PSQLV8 -- to access the files.  The Pervasive Control Center can be found by selecting Start/Run/PCC.EXE, or by navigating the Start menu for the Pervasive Control Center (in the Pervasive.SQL V8 program group, most likely).  

When you open the PCC, start clicking on "plus" signs (+) until you see the database list, then open the database in question.  If USER.DDF exists, then the database may be password-protected, so enter the appropriate username and password.  (There is no default password -- the primary user name is "Master", and the password will be whatever the person who enabled security typed in at that time.  Both are case sensitive.)

When you have the database open, select "Wizards" from the menu and then select Export Data..., and you should be able to specify a CSV export right there.
0
 
ArunVashistAuthor Commented:
Hi BillBach,

Thanks for your reply, well now the problem is I don;t have a PSQLV8 installed, can you tell me the link to download the demo version.

thanks,
0
 
Bill BachPresidentCommented:
You can download a 30-day trial of Pervasive PSQL v10 from www.pervasive.com. It will read the 8.x files with ease.

Please note, though, that because the RI constraints exist, you must create the EXACT SAME database name on any new system for it to work.

I recommend instead just using the original server, which will have everything set up correctly already.
0
 
ArunVashistAuthor Commented:
Hi BillBach,

I have installed Pervasive PSQL V10 Server, but there is no option to import data. please guide.

thanks,
0
 
Bill BachPresidentCommented:
Why are you trying to import data?  The data is already in PSQL format.

Use the PCC to create your database, with the same name that was used on the original system and the directory that contains the data files and DDF files. Then, open up the database in PCC, and you should see the tables.

You can now access them directly from ODBC, or you can use the PCC to export data (right click on the table and select Export).

If you get a Status 71 back, then you have the wrong database name.
0
 
ArunVashistAuthor Commented:
Hi BillBach,

I am trying to open it as per your instructions but its asking me for a Login credentials, what to do now, we don;t have these credentials. it giving me Status 7011.

thanks
0
 
ArunVashistAuthor Commented:
Hi BillBach,

Actually its asking login information for the local server [I have installed Ver. 10], but how to get this login information.

thanks,
0
 
Bill BachPresidentCommented:
Since the database files already exist, be sure to UNCHECK the option "Create Dictionary Files" before you click OK when creating the database.

If this doesn't help, then post a copy of your exact steps you are doing and the dialog box showing the error, so that we are on the same page.  (We typically handle stuff like this in seconds via a remote control session for our paying customers, but that's beyond the scope of EE today.)
0
 
Bill BachPresidentCommented:
There are two types of logins -- a SQL Login and an OS-level login.  Theone you need depends on the exact dialog box that you are getting.  

If you need an OS login, use the server Administrator login, and it should work fine.
If you need a SQL login, then ask the person who enabled security on the database for the proper user name and password. The database-admin username is "Master"  (which is case sensitive), but the password is determined by whomever enabled security.
0
 
ArunVashistAuthor Commented:
Hi BillBach,

Thanks Now I am able to connect to database and its now showing it as connected database in Server TreeView, but now its asking me a login/password for database, which we don;t have. Can we reset the database password.

Let me tell you one more thing, we are trying to migrate data from "NDCLytec Scheduler Professional" software. Can we convert this database to Access, XML or Excel.

thanks,
0
 
Bill BachPresidentCommented:
This is definitely the SQL password now.  You would need to get any such password from NDC/Lytec.  In my notes, I show that older versions such as 2004 didn't have any security, but that newer versions might as they added HIPAA-required security controls.  
0
 
ArunVashistAuthor Commented:
thanks,
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now