# Navision into SQL with ADO

**URL:** <https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881>\
**Category:** Technical Forum\
**Created:** [April 18, 2005, 11:33pm UTC](https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881 "2005-04-18T23:33:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jwilder](https://avatars.discourse-cdn.com/v4/letter/j/a87d85/32.png) [@Jwilder](https://www.dynamicsuser.net/u/Jwilder)\
**Post date:** [April 18, 2005, 11:33pm UTC](https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881/1 "2005-04-18T23:33:01Z")

</div>

I have connected Navision to a SQL database using ADO. Certain fields though are causing the following error: This message is for C/AL programmers: This data type is not supported by C/SIDE. You can access data from any of the following data types: VT\_VOID, VT\_I2, VT\_I4, VT\_R4, VT\_R8, VT\_CY, VT\_DATE, VT\_BSTR and VT\_BOOL I saw a previous post which talked about using an Ado.Stream object to handle these values first, but I am getting a type mismatch error when I do this. Any other solutions for this problem or more insight on the Ado.Stream solution? [Duh!]

---

<div class="post-metadata">

**Author:** ![Jwilder](https://avatars.discourse-cdn.com/v4/letter/j/a87d85/32.png) [@Jwilder](https://www.dynamicsuser.net/u/Jwilder)\
**Post date:** [April 19, 2005, 12:33pm UTC](https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881/2 "2005-04-19T12:33:58Z")

</div>

I have found the reason why the ADO.stream fix doesn’t work for me. The Type mismatch error I am getting is due to the field being null. If I filter out any null values then everything works. Anyone have experience using ADO Streams when null values are involved?

---

<div class="post-metadata">

**Author:** ![formatsn](https://avatars.discourse-cdn.com/v4/letter/f/5f8ce5/32.png) [@formatsn](https://www.dynamicsuser.net/u/formatsn)\
**Post date:** [May 3, 2005, 10:26pm UTC](https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881/3 "2005-05-03T22:26:09Z")

</div>

> **quote:**
> 
> | I have found the reason why the ADO.stream fix doesn’t work for me. The Type mismatch error I am getting is due to the field being null. If I filter out any null values then everything works. Anyone have experience using ADO Streams when null values are involved?  
> _Originally posted by jwilder - 2005 Apr 19 : 13:33:58_  
> |
> | --- |

is not possible to use fields being NULL - wk-text := varobject.value where varobject is field in automation you can use

wklen := varobject.actualsize; evaluate(wk-numeric,wklen); if wk-numeric \> 0 then wk-text := varobject.value;

bye

---

<div class="post-metadata">

**Author:** ![Moderator1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Moderator1](https://www.dynamicsuser.net/u/Moderator1)\
**Post date:** [August 19, 2007, 1:08pm UTC](https://www.dynamicsuser.net/t/navision-into-sql-with-ado/9881/4 "2007-08-19T13:08:20Z")

</div>

Moved to SQL Forums