List of databases

[Arijit]

Hi,

Is there any way to determine the list of databases present in a server and the ports opened for them?

Thanks,

Arijit.

 

[Casper]

What OS?
Do you want database or runnig databases?

Casper.

 

[Arijit]

Hi,

The OS is Windows XP. And the databases are both running and not running.

Thanks and regards,
Arijit.

 

[Casper]

XP isn't even a real platform :awink:

I'm more of a Unix guy, but if you have XP then you could manage your databases with progress Explorer. With Progress explorer you can see any database instance you created in Progress explorer.

The ports they are using is somewhat different. What ports do you mean? Do you mean the broker ports or the server ports or...?

Casper.

 

[Arijit]

Hi,
My requirement is a script for determining the databases present in the box. The progress explorer gives the databases created in Progress Explorer, not created using command line utilities eg. prodb etc.

The ports are the database server ports used when starting the database.

Thanks and regards,
Arijit.

 

[TomBascom]

On Windows you could do something along the lines of:

cd \
dir /s *.db

To find all of the files that might be Progress databases. Once you have that list you would then have to check each one because ".db" is a fairly common file extension.

 

[comatt1]

On Windows you could do something along the lines of:

cd \
dir /s *.db

To find all of the files that might be Progress databases. Once you have that list you would then have to check each one because ".db" is a fairly common file extension.

I was going to suggest that or the .st file. The .b1 may be better too.