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).
Vsql error while trying to connect
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: Vsql error while trying to connect
Can you post you connection string from the client!
trying so hard !!!
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: Vsql error while trying to connect
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
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 !!!
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: Vsql error while trying to connect
- take a look into attach that i have placed here .
- Attachments
-
- v6.jpg (47 KiB) Viewed 31379 times
trying so hard !!!
Re: Vsql error while trying to connect
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.
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.
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: Vsql error while trying to connect
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!
Examles of GUI TOAD(30 dais free), DBVisualizer(free),DBeaver(free). just have to config the jdbc connector!
trying so hard !!!
Re: Vsql error while trying to connect
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.
Have a nice day.