How can I connect to a VIP from odbc connection?

ckotsidimos

I'm using VS 2010 and try to open a connection to the load balancer IP like this:

Driver=vertica; Server=192.168.1.2; UID= USER; PWD=PASS; Database=DB1;

The problem is that I receive the error:

System.Data.Odbc.OdbcException (0x80131937): ERROR [08001] [Vertica][VerticaDSII] (160) Connection attempt failed: could not connect to server: Connection timed out (0x0000274C/10060)
 Is the server running on host "192.168.1.2" and accepting
 TCP/IP connections on port 5433?

Using the ip of any node works. Connecting through jdbc with dbeaver works. Conenct through vsql from my pc works.

Can you help?

Daniel_Leybovic

1. Vertica supports for VS2008 only
https://my.vertica.com/docs/6.1.x/HTML/index.htm#2761.htm

Programmatically using the ADO.NET driver provided by HP Vertica, as described in Programming ADO.NET Applications in the Programmer's Guide.
The HP Vertica driver for ADO.NET allows applications written in C# and Visual Studio 2008 to read data from, update, and load data into HP Vertica databases. It provides a data adapter that facilitates reading data from a database into a data set, and then writing changed data from the data set back to the database. It also provides a data reader (VerticaDataReader) for reading data and autocommit functionality for committing transactions automatically.

2. Where did you find "driver" in connection string?
https://my.vertica.com/docs/6.1.x/HTML/index.htm#14464.htm
https://my.vertica.com/docs/6.1.x/HTML/index.htm#11613.htm
https://my.vertica.com/docs/6.1.x/HTML/index.htm#11617.htm

ckotsidimos

Hi,

From the ODB drivers from windows, I created a new connection to Vertica. BTW the reason that it was not working it was because I had connection pooling enabled.

The test was done through VS 2010. The program is a web service that it is connecting to Vertica.

I will talk more with the developer who created this and I will tell you more details soon.