Configuration of ODBC Clients

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.