Skip to main content

ADO.NET client list the databases

  • March 23, 2023
  • 1 reply
  • 0 views
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'.

    1 reply

    Bryan_H
    Forum|alt.badge.img+2
    • Bryan_H
    • Participating Frequently
    • March 24, 2023

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement