# SQL Server Linked Server

**URL:** <https://community.dremio.com/t/sql-server-linked-server/1069>\
**Category:** Uncategorized\
**Created:** [May 1, 2018, 11:02pm UTC](https://community.dremio.com/t/sql-server-linked-server/1069 "2018-05-01T23:02:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Takashi.Binns](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@Takashi.Binns](https://community.dremio.com/u/Takashi.Binns)\
**Post date:** [May 1, 2018, 11:02pm UTC](https://community.dremio.com/t/sql-server-linked-server/1069/1 "2018-05-01T23:02:17Z")

</div>

I’m trying to add Dremio as a linked server in MS SQL Server Express 2017, but hitting a snag. I’ve added the Linked Server to Dremio using ODBC just fine, and can run OPENQUERY to pull dates and numeric fields, but whenever I query for a text field I get the following issue:

_The OLE DB provider “MSDASQL” for linked server “DREMIO” supplied inconsistent metadata for a column. The column “Category” (compile-time ordinal 1) of object “SELECT “Category” FROM “Sample Data”.“SF Crime Data” limit 100” was reported to have a “DBCOLUMNFLAGS\_ISLONG” of 128 at compile time and 0 at run time._

Has anyone else experienced this and found a workaround?

thanks!  
-Takashi

---

<div class="post-metadata">

**Author:** ![Sharon](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sharon](https://community.dremio.com/u/Sharon)\
**Post date:** [May 2, 2018, 8:28am UTC](https://community.dremio.com/t/sql-server-linked-server/1069/2 "2018-05-02T08:28:27Z")

</div>

Hi @Takashi.Binns

This is a known issue we are tracking internally.  
Unfortunately we still do not have an ETA for a fix.

---

<div class="post-metadata">

**Author:** ![Takashi.Binns](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@Takashi.Binns](https://community.dremio.com/u/Takashi.Binns)\
**Post date:** [May 4, 2018, 10:33pm UTC](https://community.dremio.com/t/sql-server-linked-server/1069/3 "2018-05-04T22:33:22Z")

</div>

Hi Sharon,  
Thanks for the quick update! Do you know if I’ll run into a similar issue if I tried using an Oracle database link?  
thanks,  
-Takashi

---

<div class="post-metadata">

**Author:** ![Sharon](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@Sharon](https://community.dremio.com/u/Sharon)\
**Post date:** [May 10, 2018, 10:52am UTC](https://community.dremio.com/t/sql-server-linked-server/1069/4 "2018-05-10T10:52:48Z")

</div>

@Takashi.Binns - I do not see similar known issues with respect to Oracle dblink, though it might have just not been reported so if you do find an issue please do let us know.

Out of curiosity - I’m assuming your use case is to join SQL Server/Oracle tables with other Dremio’s datasets. Have you considered mapping these databases into Dremio and applying the joins there (via UI/ODBC/JDBC/REST API)? The latter would also leverage Dremio’s optimizations and acceleration.  
Unless you’re looking at other use cases which require specific MSSQL/Oracle functionality against Dremio’s datasets?

---

<div class="post-metadata">

**Author:** ![Dgutierrez](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@Dgutierrez](https://community.dremio.com/u/Dgutierrez)\
**Post date:** [January 16, 2019, 5:11pm UTC](https://community.dremio.com/t/sql-server-linked-server/1069/5 "2019-01-16T17:11:45Z")

</div>

Any updates with this error? I’m still getting them.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 17, 2019, 8:53pm UTC](https://community.dremio.com/t/sql-server-linked-server/1069/6 "2019-01-17T20:53:17Z")

</div>

Hi @Dgutierrez

Are you getting an error from SQL server linked server or Oracle DB link

Thanks  
@balaji.ramaswamy