The Vertica Database Forums

Hi All,

I have installed the vertica community edition instance on a linux host and vertica windows client package on a remote windows desktop. I am able to access vsql on the Linux Host machine. While trying to access the vsql application on the client Windows desktop, the launch of the vsql application fails. Upon trying to connect vsql from the Windows command prompt, I received the error message given below.

C:\Program Files\Vertica Systems\bin>vsql.exe
vsql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5433?

So I tried connecting with vsql by supplying the host name, user and password at command line and it connected successfully. So my question is how do I mention the host name, user and password while trying to connect from the Windows vsql application(not from command line).

Can you post you connection string from the client!

The sintax to be used to connect to your vertica instance is :

vsql -h<hostname/ip address> -U<username/dbadmin> -w<password>

- make sure you have installed the vertica client on you Windozzzzz sistem

- take a look into attach that i have placed here .

Hi,

Thank you for your reply. But like I said I am able to connect from the Windows Command Line using the vsql - h -U -w syntax.

I think I should rephrase my question as "Can vsql be used as a GUI client as well. If yes, then how can I specify the host name, user and password while launching the vsql application from Windows GUI."

From your previous reply, I get the feeling that vsql is not a GUI application and can only be used as CLI. Is there a GUI client for querying Vertica. Please let me know.

Vsql is the native client in Vertica .
Examles of GUI TOAD(30 dais free), DBVisualizer(free),DBeaver(free). just have to config the jdbc connector!

I also having the same problem issue how you guys solve this problem ? I already install vertica jdbc driver on my window os .But when I fill up all necessary thinga(servername,databasename,etc),the error pop up.So plz help me asap.
Have a nice day.