Connection refused in MAC

Rishi_De

I have installed vsql and database in my MAC. but while connecting from vsql m getting following error 
vsql: could not connect to server: Connection refused Is the server running on host "???" and accepting
TCP/IP connections on port 5433?

am executing following command,
vsql  -U dbadmin -w password

and my odbc.ini is like ,

[VMart]Description = Vmart Database
Driver = /Library/ODBC/vertica/lib64/libverticaodbc.dylib
Database = vmartdb
Servername = host01
UID = dbadmin
PWD = password
Port = 5433
Locale = en_GB

Matt_Oldham

If you are trying to connect using vsql, then you are not using an ODBC connection.  Try adding the "-h host01" parameter to your vsql command.

Rishi_De

Hi ,

After adding host name , am getting following error ,

vsql: could not translate host name "host01" to address: nodename nor servname provided, or not known

Please help

Navin_C

Hello Rishi,

Please check if your database is up and running.