ODBC error Fatal 2983 Database does not exist

Rama_krishna_ku

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.

Navin_C

Hi Rama,

Check if database crrg is UP or down.

Hope this helps.
NC

Rama_krishna_ku

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.

Rama_krishna_ku

                        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.

Navin_C

Check the database name from your Command line tools.

select * from databases ;
OR
Select current_database() ;

Maybe the DBA must have given you the schema name to connect.

Hope this helps.

Rama_krishna_ku

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