We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Stability problem with ODBC connection — Vertica Forum

Stability problem with ODBC connection

Lai_Nam_KhimLai_Nam_Khim
in General Discussion
I am having a lot stability problems with connections to Vertica database from Windows via ODBC connection.

I have Vertica 6.0 ODBC drivers installed. I have no problem connecting to the database.

The problem is staying connected. I keep getting disconnected. All my users are encountering the same problem and they are very frustrated.

If I use a JDBC client and connect using the JDBC driver, I do not have such problem. I can stay connected the whole day. So I am quite sure the problem is not with the database or the network. It is the drive.

I end up relying on the JDBC drivers, but many users are using tools that still rely on ODBC connections.

Is this a known problem? Are there settings that can improve the situation?

Comments

  • Prasanta_PalPrasanta_Pal - Select Field - Employee
    Can you try?
    # echo 600 > /proc/sys/net/ipv4/tcp_keepalive_time

    What is the error message when there is not connection?




Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...