How can I get list of all databases stored on server?

Greetings to all...

I work on project (Visual FoxPro 9.0 + Firebird 1.5.2). Very strange combination, but it was not my decision. Now I have one problem.

I don't know how to get list of all databases, they are stored on server. I don't want to do it via ISQL interactive mode. I have to do it programmaticaly, I need this information in my aplication internal.

Sorry for my english, it's simple and maybe my problem is also very simple, but I'm new in Firebird.

Thanks...

There is no way to do that! BTW, why do you need that?
Perhaps you can use this tool: http://www.achim-kalwa.de/fbcc.phtml to help you with that task.

Again, there is no mechanism to provide you with the list of all databases on server. Firebird doesn't know anything about that, and it is right decision, IMHO.

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org/shownews.php

Thank you for your answer.

I want that users of my application can see list of databases. For example, when the program starts, they choose which database they want to use. Each database is another company, for example. So, this is the reason.

MSSQL has a system stored procedure for this feature...

Thanks again.

Why not have a central db which stores the list of available databases, their location, a more descriptive name and login information?

I thought about that solution. It's good. But I was accustomed to this ability from MSSQL.
Thanks.

I have found this tool:

http://www.tectsoft.net/Products/IBAM.aspx

Interbase Alias Manager (IBam) is an Open Source Delphi 5 project which centrally manages Interbase and Firebird connection strings. (IBam is subject to the MOZILLA PUBLIC LICENSE ).


--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org

You can make a server application that runs on the firebird server and comunicate with it and ask for a list of databases ... but hey ... what's the point ?

Ok, I wrote I used this ability in MSSQL. Now I know, Firebird don't support this. That's all. I have to solve this another way. But you wrote, I can get list ofa databases. How???
Thanks...

Well basically you have an app (let's name it server_app that runs on the FireBird server) and one (or more, client_app).
The client_app makes a request to the server_app for the databases, and the server_app checks the folder(s) where you store the databases for .fdb files and returns a list of them. (in theory that looks easy but it takes time to code)

Another way would be to have a list of databases stored on the server and sincronize it with the clients list (multiple ways to do that and much easier than the first, you can also encrypt the contents so that anyone looking wouldn't see the real text).

Good luck & please share your final solution with us

Nope, it is a not strange combination, but I dare to say very powerful . I do it too. Join form different databases, dynamic sorting/indexing at client side, etc.

I suggest you to have a "database of databases" which keeps a list of accessible databases from your app.
I don't see any benefit if some user can see ALL databases. It is a security problem, IMO, if something like this is possible.

You can also try to see if my Firebird API wrapper class is usefull to you. Is posted on UniversalThread download section

I'm glad I found someone who used this combination (VFP+Firebird).
I want that users of my aplication can see a list of all accessible databases. So, it is not ALL DATABASES, I wrote it wrong. "Database of databases" is a good solution. I made it this way.
I tried your API wrapper class. It is very useful.
Thank you.

Hi, I am also a member of the UT. I'm beginning to use Firebird 1.5 with VFP 9 and I guess I'll find some problems, maybe you canhelp me with those as a seasoned VFP/Firebird developer.

Greetings,

Skysurfer

If I can help, I will.
I visit UT more often, you can post there if you want.