Configuration of ODBC Clients

You are looking at an older version of the documentation. The latest version is found here.

Here is what you need to configure ODBC clients to work with Kerberos authentication:

• The Data Virtuality ODBC driver needs to be installed.
• The minimal version of an ODBC driver to be able to participate in Kerberos authentication is 22.00.01.00.
• If you are configuring participation in Kerberos Authentication using a DSN:
  • The DSN can be configured and tested with "Windows ODBC Admin".

  • Add the following as libpq parameters in DSN configuration → Data source → Page 3 → libpq parameters:

    TEXT

    gsslib=gssapi krbsrvname=DVServer

• Configure participation in Kerberos authentication using an ODBC connection URL:

  TEXT

  DRIVER={DataVirtuality Unicode(x64)};D6={gsslib=gssapi krbsrvname=DVServer};SSLmode=disable;PORT=<port>;SERVER=<server>;DATABASE=datavirtuality

  Here is an example:

  TEXT

  DRIVER={DataVirtuality Unicode(x64)};D6={gsslib=gssapi krbsrvname=DVServer};SSLmode=disable;PORT=35434;SERVER=DV01;DATABASE=datavirtuality

If the ODBC client requires a username and password to be specified, you can provide bogus/dummy values for both.