Skip to main content

How can I connect to a VIP from odbc connection?

  • November 14, 2013
  • 2 replies
  • 15 views
ckotsidimos
Forum|alt.badge.img+1

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?

    2 replies

    Daniel_Leybovic
    Forum|alt.badge.img+1
    • Daniel_Leybovic
    • Participating Frequently
    • November 14, 2013
    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
    Forum|alt.badge.img+1
    • ckotsidimos
    • Author
    • Participating Frequently
    • November 15, 2013


    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement