ADO.NET client list the databases

kamil_kliczborkamil_kliczbor Community Edition User
edited March 2023 in General Discussion

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