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.
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.
+2Hi Rama,
Check if database crrg is UP or down.
Hope this helps.
NC
Check if database crrg is UP or down.
Hope this helps.
NC
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.
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.
+2Check the database name from your Command line tools.
Hope this helps.
select * from databases ;Maybe the DBA must have given you the schema name to connect.
OR
Select current_database() ;
Hope this helps.
Thanks Navin! You were right on. We had the schema name, not the database name.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
