Vsql error while trying to connect

Moderator: NorbertKrupa

Post Reply
sdennyk
Newbie
Newbie
Posts: 2
Joined: Tue Feb 26, 2013 12:25 pm

Vsql error while trying to connect

Post by sdennyk » Tue Feb 26, 2013 12:37 pm

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).

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error while trying to connect

Post by adrian.oprea » Tue Feb 26, 2013 1:51 pm

Can you post you connection string from the client!
trying so hard !!!

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error while trying to connect

Post by adrian.oprea » Tue Feb 26, 2013 4:52 pm

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
trying so hard !!!

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error while trying to connect

Post by adrian.oprea » Tue Feb 26, 2013 5:15 pm

- take a look into attach that i have placed here .
Attachments
v6.jpg
v6.jpg (47 KiB) Viewed 5773 times
trying so hard !!!

sdennyk
Newbie
Newbie
Posts: 2
Joined: Tue Feb 26, 2013 12:25 pm

Re: Vsql error while trying to connect

Post by sdennyk » Tue Feb 26, 2013 5:27 pm

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.

adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Re: Vsql error while trying to connect

Post by adrian.oprea » Wed Feb 27, 2013 1:18 pm

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! 8-)
trying so hard !!!

khine
Beginner
Beginner
Posts: 33
Joined: Wed Apr 03, 2013 2:54 am

Re: Vsql error while trying to connect

Post by khine » Sat May 18, 2013 1:07 am

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.

Post Reply

Return to “Vertica Error Codes”