# Elasticsearch ODBC driver with SQL Linked Server

**URL:** <https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144>\
**Category:** Elasticsearch\
**Created:** [February 27, 2020, 5:15am UTC](https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144 "2020-02-27T05:15:59Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\
**Post date:** [March 18, 2020, 8:42am UTC](https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144/14 "2020-03-18T08:42:05Z")

</div>

There are indeed a couple of issues, but the outstanding one is the incompatibility of Elasticsearch/SQL's string types with Linked Servers/MSSQL's (namely, the lengths), even when using the query pass-through ([`OPENQUERY`](http://docs.microsoft.com/de-de/sql/t-sql/functions/openquery-transact-sql)).  
We've decided to add support for this application, but it requires dedicated work, so it'll unfortunately have to wait for one of the following non-patch releases.  
This is btw an issue that Linked Servers/MSSQL has with other DBs/drivers out there (search phrase [`Requested conversion is not supported.`](https://duckduckgo.com/?q=Requested+conversion+is+not+supported))

---

_[View the full topic](https://discuss.elastic.co/t/elasticsearch-odbc-driver-with-sql-linked-server/221144)._