Options

ADO.NET client list the databases

kamil_kliczborkamil_kliczbor Community Edition User ✭
edited March 2023 in General Discussion

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'.

Comments

  • Options
    Bryan_HBryan_H Vertica Employee Administrator

    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.

This discussion has been closed.