ODBC error Fatal 2983 Database does not exist

I am trying to connect our vertica database and i get a database not found error. I have verified everything in my ODBC driver manager. Can any one help me identify what is causing this.


  • Options
    Navin_CNavin_C Vertica Customer
    Hi Rama,

    Check if database crrg is UP or down.

    Hope this helps.
  • Options
    It is up and i am able to access it via the command line, only the ODBC driver configuration seems to be the problem to connect to the db via a SQL tool.
  • Options
                            List of tables

    Schema |          Name           | Kind  |  Owner  | Comment


    crrg   | a1                      | table | dbadmin | 

    I am using "crrg" as my database name in my ODBC connection configuration and that is what our DBA said is the database. Could it be different because in the list of tables above, i see "crrg" to be the schema name.

  • Options
    Navin_CNavin_C Vertica Customer
    Check the database name from your Command line tools.
    select * from databases ;
    Select current_database() ;
    Maybe the DBA must have given you the schema name to connect.

    Hope this helps.

  • Options
    Thanks Navin! You were right on. We had the schema name, not the database name.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file