I have a recordset with rows that I am pulling into a VB6 app from SQL Server 2000 via ADO, and one of the fields is giving me only nulls.
r.Fields("Name").Value is how I am accessing it. In sql server it is of type varchar, and it is intended to be a field that can hold numbers and strings (which is why I made it varchar).
Is there anything I need to know about this datatype, or the way I am accessing it, which would prevent these nulls?
Other columns from the same query are returning values in my vb app, and the same exact query in SQL Server query analyzer is returning data for the column "Name"...
Thanks in advance!