# MSSQL Bug still there , any workarounds?

**URL:** <https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871>\
**Category:** Databases\
**Created:** [June 11, 2021, 4:48pm UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871 "2021-06-11T16:48:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aurelian\_N](https://forum.xojo.com/letter_avatar_proxy/v4/letter/a/b4bc9f/32.png) [@Aurelian\_N](https://forum.xojo.com/u/Aurelian_N)\
**Post date:** [June 11, 2021, 4:48pm UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871/1 "2021-06-11T16:48:49Z")

</div>

Hello guys,

Apparently I needed to use a MSSQL server to fetch some data and again I discovered that is impossible with XOJO, the Database Exception is simply throws error and a link to a bug that does not exist anymore . Checking on the forum for similar issues I get this [DB Error on SQLSelect - Error retrieving large column values](https://forum.xojo.com/t/db-error-on-sqlselect-error-retrieving-large-column-values/19538) , so in 2021 still we cannot use xojo on Windows with the windows products ?

Is there any workaround at the current date ?

Thanks.

---

<div class="post-metadata">

**Author:** ![Aurelian\_N](https://forum.xojo.com/letter_avatar_proxy/v4/letter/a/b4bc9f/32.png) [@Aurelian\_N](https://forum.xojo.com/u/Aurelian_N)\
**Post date:** [June 11, 2021, 4:54pm UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871/2 "2021-06-11T16:54:17Z")

</div>

So can someone from [@XOJO](https://forum.xojo.com/groups/xojo) explain what “Error retrieving large column values due to a bug in the SQL Native Client ([https://connect.microsoft.com/SQLServer/feedback/details/467300/problem-with-varchar-max-via-sql-native-client](https://connect.microsoft.com/SQLServer/feedback/details/467300/problem-with-varchar-max-via-sql-native-client)).” and what can be done, as eventually that plugin supposed to work, what Large Column Values means ? I tried to fetch 1 record, then 1 record and 1 column, what is the limit for that ? or we cannot use it at all ? , I mean it was nice of you to mention the bug on Microsoft but that is more an excuse than a functional product, or at least this is how I see it.

On Examples in XOJO there is nothing mentioning that or a workaround for it. so why we still have that driver ? just to be there ?

Thanks

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [June 11, 2021, 5:55pm UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871/3 "2021-06-11T17:55:16Z")

</div>

We can recommend our [MBS Xojo SQL Plugin](https://www.monkeybreadsoftware.de/xojo/plugin-sql.shtml) as an alternative way to connect to MS SQL Server.

---

<div class="post-metadata">

**Author:** ![Aurelian\_N](https://forum.xojo.com/letter_avatar_proxy/v4/letter/a/b4bc9f/32.png) [@Aurelian\_N](https://forum.xojo.com/u/Aurelian_N)\
**Post date:** [June 12, 2021, 4:13am UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871/4 "2021-06-12T04:13:47Z")

</div>

Hi Christian,

If that means not installing 40 + plugins to have that then we will consider that option.

Thanks.

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [June 12, 2021, 7:58am UTC](https://forum.xojo.com/t/mssql-bug-still-there-any-workarounds/63871/5 "2021-06-12T07:58:14Z")

</div>

[MBS Xojo SQL Plugin](https://www.monkeybreadsoftware.de/xojo/plugin-sql.shtml) is just one file.