Skip to main content

Stability problem with ODBC connection

  • June 25, 2014
  • 1 reply
  • 3 views

Lai_Nam_Khim
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?

1 reply

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • June 27, 2014
Can you try?
# echo 600 > /proc/sys/net/ipv4/tcp_keepalive_time

What is the error message when there is not connection?