In Delphi, TEDBSession has the 'GetDatabaseNames' and 'GetDatabases'
methods. How do I achieve the same thing with the ADO.NET provider?

The EDBConnection object seems to be roughly equivalent to a combination of
the VCL TEDBSession and TEDBDatabase objects, but I can't see any way of
retrieving a list of all the available databases for the selected Config
path.

Specifically, I need to get back a list of both database NAMES and also the
FOLDER PATH of each database.

Any ideas please?!

Ahah! I can answer my own question!

Connect to the "Configuration" database and perform 'select * from
databases'

Hedley

>Specifically, I need to get back a list of both database NAMES and also the
>FOLDER PATH of each database.

Again I know nothing about .Net but you should be able to query the configuration database. Try this in EDBManager

select * from databases

Just select the session not a database otherwise, if you select a database you'll have to use

select * from configuration.databases

You should be able to convert this to .net (I hope)

Roy Lambert [Team Elevate]

Hedley


You beat me by about 15 mins - ONLY because I was interrupted in my posting
Roy Lambert