[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

How Can I Determine Username on Delphi Interbase DB?

I have a collection of database files which were embedded in an executable that I have determined to be written in Delphi 7 (I ran DeDe on it.) What I want to do is be able to write an app that can read these database files and do reports. I do not have the source code. Is it possible to:
1. determine if they are, in fact, Interbase files;
2. find out the username and password for these files?

Also, what is the best way to connect to this database from Visual Studio 2005?
0
rkulp
Asked:
rkulp
  • 2
  • 2
1 Solution
 
rkulpAuthor Commented:
I failed to mention that the files are located on the local host. Also, I found this posting after submitting my question. It suggests a provider:
 http://www.experts-exchange.com/Database/Interbase_Firebird/Q_20917650.html.

I still need to be able to determine the username and password, if any.
0
 
dprochownikCommented:
On Firebird there is no users nor passwords to database file. These data are stored on server side, so if you will install Firebird then you will have one default user SYSDBA with password masterkey, which you can use to connect to any database throught this FB server.
Firebird is based on Interbase so I suppose this should work for Interbase too.
0
 
rkulpAuthor Commented:
dprochownik:

I think you are correct. Unfortunately, I tried it with the IBProvider and got an error message that the file was not a valid database. So, this seems to answer the first question and leads to the question: What kind of database is it? There is a cdx file for each of the udb files. The same structure is in another folder where all the files are sdb. The first letter of the extension matches the first letter of the folder name. I don't think the extension follows any of the standard default extensions.
I will accept this answer but would appreciate any suggestions you have about detecting the true db. Thanks for your quick response.
0
 
dprochownikCommented:
Don't give up so quickly :)
Check on which version of Interbase or Firebird did you try to connect, because in FB for example, you won't connect to database created/restored by FB 2.x using FB1.x. It might be similar in Interbase
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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