search

elastic / elasticsearch-sql-odbc

ODBC driver for Elasticsearch SQL
Other
0 stars 30 forks source link

8.4.3 ODBC Driver unable to establish the connection #314

Closed hemantmalik closed 2 years ago

hemantmalik commented 2 years ago

Environment

Windows Server 2022 Datacenter Azure Edition (21H2) No Proxy US Location

Expected Behaviour

Test Connection successful

Actual Behaviour

image

Steps to reproduce the behavior

  1. Install ODBC Driver
  2. Configure DSN
  3. Test Connection

DEBUG log file esodbc_20221020214711___2608-2.log

cc: @jeffmaddocks @bpintea

bpintea commented 2 years ago

This is caused by the unfortunate delayed introduction of the Version type support to the ODBC driver (see comment). The workaround is to use an older version of the driver. 8.5 will work as expected too (as well as a potential 8.4.4, but this doesn't seem it'll be released).

jeffmaddocks commented 2 years ago

Thanks @bpintea, I went thru the drivers back to 8.3.3, which worked. I will work with Hemant to identify the right channel to have our documentation updated.