# ODBC driver crash

**URL:** <https://forum.opensearch.org/t/odbc-driver-crash/3693>\
**Category:** Open Source Elasticsearch and Kibana\
**Created:** [September 7, 2020, 12:33pm UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693 "2020-09-07T12:33:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Floris](https://avatars.discourse-cdn.com/v4/letter/f/a3d4f5/32.png) [@Floris](https://forum.opensearch.org/u/Floris)\
**Post date:** [September 7, 2020, 12:33pm UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/1 "2020-09-07T12:33:18Z")

</div>

Hi,  
Im trying to connect elasticsearch to power-bi using the Open Distro ODBC driver, but the problem is that the (64bit version) crashes when i click on “Test”.  
Ive tried both the elasticsearch version that Open Distro provides and the one that is available on the elastichstack website.

These are the settings i used for the configuration of the elasticsearch version provided by Open Distro.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/1X/854738f1d05347afcb4dd76b34e72c4f40a8fc71.png)

I also tried installing the 32bit version of the driver. While using the same settings this driver didnt crash, tho it did gave the following error:  
Connection error: [Open Distro For Elasticsearch][SQL ODBC Driver][SQL Plugin] Connection error: failed to establish connection to DB.

Also i can connect perfectly fine when i use the following shell command:  
curl -XGET [https://localhost:9200](https://localhost:9200) -u admin:admin --insecure

Thanks in advance for the help!

---

<div class="post-metadata">

**Author:** ![stmx38](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/stmx38/32/4354_2.png) [@stmx38](https://forum.opensearch.org/u/stmx38)\
**Post date:** [September 7, 2020, 2:41pm UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/2 "2020-09-07T14:41:41Z")

</div>

@Floris, what is about checkbox “Hostname Verification”? For curl you use `--insecure`.

---

<div class="post-metadata">

**Author:** ![Floris](https://avatars.discourse-cdn.com/v4/letter/f/a3d4f5/32.png) [@Floris](https://forum.opensearch.org/u/Floris)\
**Post date:** [September 8, 2020, 6:24am UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/3 "2020-09-08T06:24:08Z")

</div>

Im still new to Elastic and opendisistro, so im just trying to follow the documentation to get things to work.

To verify the installation of the opdistro version of elasticsearch i have to use the --insecure command:

> **[Windows](https://opendistro.github.io/for-elasticsearch-docs/docs/install/windows/)**
>
> Documentation for Open Distro, the community-driven, 100% open source distribution of Elasticsearch OSS with advanced security, alerting, deep performance analysis, and more.

And the hostname verification checkbox i checked since thats also what the exaple does in the documentation, altho i have tried unchecking the checkbox. Tho that also didnt work for me.

> <https://github.com/opendistro-for-elasticsearch/sql/blob/develop/sql-odbc/docs/user/windows_configure_dsn.md>

---

<div class="post-metadata">

**Author:** ![stmx38](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/stmx38/32/4354_2.png) [@stmx38](https://forum.opensearch.org/u/stmx38)\
**Post date:** [September 8, 2020, 7:38am UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/4 "2020-09-08T07:38:13Z")

</div>

I mean, if we use `--insecure` with curl which is used in case when we use a self-signed certificate to secure connection to the cluster, we probably should also try to disable ‘Hostname Verification’.

---

<div class="post-metadata">

**Author:** ![Floris](https://avatars.discourse-cdn.com/v4/letter/f/a3d4f5/32.png) [@Floris](https://forum.opensearch.org/u/Floris)\
**Post date:** [September 8, 2020, 10:50am UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/5 "2020-09-08T10:50:44Z")

</div>

I just tried it, but i still have the problem that when i click on “test” both the “ODBS Data Sources” app from windows and the driver DNS setup from Distro closes for no reason.

---

<div class="post-metadata">

**Author:** ![shahrukh](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@shahrukh](https://forum.opensearch.org/u/shahrukh)\
**Post date:** [February 17, 2021, 8:26am UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/6 "2021-02-17T08:26:17Z")

</div>

Hi ,  
The driver configuration and testing connection work  
but after the connection to POWER BI the data is restricted to a small chunk.  
I am able to load only 200 row where as my table (index ) on ElasticSearch contain millions of row.

---

<div class="post-metadata">

**Author:** ![chloe-zh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/chloe-zh/32/1142_2.png) [@chloe-zh](https://forum.opensearch.org/u/chloe-zh)\
**Post date:** [February 17, 2021, 9:32pm UTC](https://forum.opensearch.org/t/odbc-driver-crash/3693/7 "2021-02-17T21:32:41Z")

</div>

Hi @shahrukh

This is because the default size limit is 200 for the query engine. You can update the limit and enable the cursor if necessary within the SQL plugin, check out the reference here: [sql/settings.rst at develop · opendistro-for-elasticsearch/sql · GitHub](https://github.com/opendistro-for-elasticsearch/sql/blob/develop/docs/user/admin/settings.rst#opendistro-query-size-limit)