Why does ADO think that values of datatype text are always NULL?

[bdotzour]

I'm using VB and ADO to access my SQL Server 7 tables. The problem I'm running into is that one of my columns is of type TEXT. When I open the recordset on this table, all of the values in the text column are NULL, even when there is definitely data in that column.

Does anyone know what gives here?

 

[aalmeida]

- First make sure that the receiving Data type is correct.
- Second make sure you are not concatenating with null values since the result will allawys be null some times you need to set Var values to ' ' (Blank Space) so it would no be null, on sql you could use SELECT isnull(MyColumn, ' ') it will return a space when the text column has a null value.
- Remember that a colum that has nothing in it it actually have null.
I hope I'm pointing you in the right direction, but this is what I have seen on my asp's AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"