ADO.NET client list the databases

kamil_kliczbor

Hi,
is it there any chance to list all available databases using ADO.NET client without database connection string parameter?
When I try to make a DbCommand without specyfing the database on a connection string:
"select database_name from v_catalog.databases" I get
"Connection authorization failed. The following connection settings were missing: Database'.

Bryan_H

Even though there is only one database on the host, you must still log in to that database to execute the SQL to list the databases table. Because of that, you need to know the database name. This is required for all driver types, not just ADO.NET.